Export e-mail addresses in Excel to an e-mail distribution list in Word

I have a spreadsheet that has a column filled with over 100 e-mail addresses. Is there any way to export this column over to MS word and have it automatically formatted so that it's a ready to use e-mail distribution list (i.e. the semi colons between each e-mail address, etc.)?

Help?!

I download this spreadsheet daily and it has new people added constantly and I'm sick of copying and pasting into word and then having to go through and add the semi colons. There HAS to be a smarter way to do this.

Thanks so much!
Debbie

Hello Debbie,

Welcome to the Forum!

I need a little more information about this email list. Are you using this list in Word as part of a mail merge or simply dumping the the emails into an empty Word document as an archive or for something else?

Sincerely,
Leith Ross

I'm copying the e-mail column in Excel into a Word document. When I paste it into the word doc, I use "paste special" and select "Unformatted Text". So this gets me all of the e-mail addresses in the word doc, but it's not setup like a distribution list in that it doesn't have the semi colon after each e-mail address.

I'm manually adding the semi colon right now and then I copy and paste that distribution list into the To: section of the e-mail I'm sending.

Hope that made it a little more clearer. This process takes me time because the list is long, and there's got to be an easier way to e-mail from an Excel column of e-mail addresses.

So any suggestions would be appreciated.

Thanks!

Hello twinendeavors,

You're right there is an easier way. I would need to see an examp[le of your workbook layout to provide you with faster and easier solution. I really don't need to see all the addresses you are using, just which column they are in and how you start your email.

Sincerely,
Leith Ross

I am working on a similar project and I am sure there is an easier way to do this. I need to add a semi colon after each email in every cell. Line one is what i need it to look like and I just need an easier way to put a semi colon after the email address in each cell. Thanks in advanced for everyones help on this. Thanks