Mailmerge with the CC option

[sindhuja]

Hi,

Can some one assist in using the mail merge in excel 2007 with the CC and BCC options.

Also please let me know how to include the attachment in the mail merge document.

-Sindhuja

[macropod]

Hi Sindhuja,

Mailmerge doesn't directly support CC & BCC. You need to drive the whole process with a macro for that.

For code to execute a mailmerge with attachments, see: http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
To include cc, insert
.cc = "Email address1; Email address2"
Inside the With oItem - End With construction in the code in the article.
See also: http://answers.microsoft.com/en-us/office/forum/office_2007-word/mail-merge-with-cc-options2/a92a3288-844e-4fc8-95e2-350e3981c9bc