Hi ,
I use a Word 2003 mailmerge file, where i have a data source as an access
table with an email field that contains one or more email ids per field which
are separated by semicolons. When I execute the mailmerge there are no
issues when the field contains only one email id. But the issue is when
there is multiple email ids i receive the below dialog box , e.g.,
Check Names
Microsoft Office Outlook does not recognize
"xyz1@microsoft.com;xyz2@microsoft.com;xyz3@microsoft.com"
Select the address to use.
I tried changing the semicolon to colon/comma for seperating the email ids
in the field, but it does not work too..
Can I have multiple email ids in a field, use email merge and send mails
successfully via Outlook ? Could someone please let me know how to solve
the above issue..
Thank you
Doug Robbins - Word MVP - 25 Mar 2008 21:17 GMT
I am pretty sure that mailmerge can only handle one email address.
You would need to create a "roll-your-own" equivalent to Mailmerge to handle
mutliple addresses and the method and code in
the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
could be modified to do that.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
> Hi ,
> I use a Word 2003 mailmerge file, where i have a data source as an access
[quoted text clipped - 17 lines]
>
> Thank you