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 Outlook 2007 contact list without losing groups 0
Insert name and adress from a list in a word document 1
Merging from an Excel file with graphics 1
Auto Populate One Pages from spreadsheet 0
Duplicate pst, or is it? 1
Have 4 email addresses Want to auto forward all in one of them 0
Excel --> Word 4
Embed the same Excel multiple times 0

Top