General discussion


Mail Merge using Excel Data

By mdbiggar ·
I have an excel spreadsheet that lists all of my contractors. Many have multiple e-mail addresses. When I try to do a mail merge in Word to an e-mail using the excel sheet as a data source, it ignores the rows that have multiple e-mail addresses listed. I have tried separating the data in the spreadsheet using semi colons, colons, commas, etc. and this does not work. Is there any way to format the data so that word will not ignore it and hopefully send to all email addresses without making each unique e-mail address a separate row within the excel document. This work around will render the spreadsheet useless for my other tasks. I am using Office 2002. Help please!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Same problem...

by jeff.herrick In reply to Mail Merge using Excel Da ...

We recently switched from Novell to Outlook, and I was hoping this issue would be resolved, but I am having the same issues you are having, and cannot find a absolute solotion.

Can anybody help?

Collapse -


by Sue T In reply to Mail Merge using Excel Da ...

This isn't perfect but may work for what you want to do. Create a 2nd worksheet and link to the original worksheet only the fields you want to use for your mail merge. that way the information you need would be automatically inserted into the fields you specify on the new worksheet and you could then use that new worksheet for your mail merge as the extra email addresses would not be there. This would also keep your original the way you need it for your other tasks.

Related Discussions

Related Forums