Help reg mailmerge

[jon]

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
"(e-mail address removed);[email protected];[email protected]"
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]

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.

--
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