Mail merge to email adress

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kent - 29 Oct 2007 18:41 GMT

I am using Excel and Word 2003 to do a merge. In the data I have a column
containing 2 email addresses separated by a semicolon, because I want the
document to go to the employee and their manager. I did this because there
does not appear to be a CC field in the merge to email window.

When I try to merge this document to email using the field that contains 2
email addresses I get an error that the recipients can not be found. In this
error message the two email Addresses are in Quotes like this "one@domain.ca;
two@domain.ca"

I believe the quotes are the problem, how do I fix this. My goal is to merge
and send the document to two people at once for each record in my data

Reply to this Message

Doug Robbins - Word MVP - 29 Oct 2007 20:28 GMT

Word does not have the ability to do this "out of the box", but it can be
done with a macro that makes use of the Outlook Object Model.

Most of what you need to do it is in the method in the article "Mail Merge
to E-mail with Attachments" at:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

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

>I am using Excel and Word 2003 to do a merge. In the data I have a column
> containing 2 email addresses separated by a semicolon, because I want the
[quoted text clipped - 11 lines]
> merge
> and send the document to two people at once for each record in my data

Reply to this Message

Rate this thread: