Exporting data in excel to word

S

SKMSOffice

I have a list of email addresses in excel. I need to be able to paste those
addresses into an email so I need to export the column of email addresses to
word with a comma between each address, so I can paste it into my email To
field. Can anyone help?
 
M

Ms-Exl-Learner

Try this...

=A1&","

Assume that your data is in A Column so this formula should be pasted in B1
cell and drag it to the remaining cells. Because in your above post you
didn't mention that in which column the email id's are present.

Change the cell reference A1 to your desired cell.

If this post hels, Click Yes!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting email addresses 3
convert email address file in Excel 2000 to Word file with commas 8
Scripts / Macros in Word and Excel 11
Naming a Data Range 2
Locate files in Excel 1
How to extract email addresses from 1 worksheet to another workbook 11
insert a comma in multiple fields 3
Copy Excel address book to Word for subsequent use with MSN Hotmai 1

Top