Merge Email with cc contacts to specific individuals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yvonneb - 13 Mar 2007 13:09 GMT

Hi. I'm doing a merge using word/email and want to cc specific people in to
certain emails, but not all of them.

Is it possible to link one email address with one "cc to" email address?

Thanks

Reply to this Message

Doug Robbins - Word MVP - 13 Mar 2007 14:53 GMT

That cannot be done without the use of some Visual Basic code that makes use
of the Outlook Object Model.

The code in the method and following article should get you started in the
right direction: In your case, the catalog or directory type merge document
that is created should include columns containing the email addresses of the
parties to whom you want to send copies of the merge document created for
individual records.

See 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

> Hi. I'm doing a merge using word/email and want to cc specific people in
> to
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

PS - 13 Mar 2007 18:07 GMT

Hi there..

I've tried to add a column of cc email address but only the "To" receipants
got the merge email. Would you mind showing me the exact format/content in
the directory/catalog?

Should it be like this:

1st column: abc@xyz.com
2nd: 123@xyz.com
3rd: D:\Documents\JulyReport.doc

Your advice please. Many thanks.

> That cannot be done without the use of some Visual Basic code that makes use
> of the Outlook Object Model.
[quoted text clipped - 16 lines]
> >
> > Thanks

Reply to this Message

Doug Robbins - Word MVP - 14 Mar 2007 02:26 GMT

The way you have the directory/catalog set up is OK. It is the code in the
macro that needs adjusting.

However, you could probably get away without modifying the code if you put
all of the email addresses in the first column separated by the Outlook
address separator. In my case that is a semi-colon, but it may differ
depending upon the Regional Settings.

In that case, you would have in the first column

abc@xyz.com; 123@xyz.com

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 there..
>
[quoted text clipped - 38 lines]
>> >
>> > Thanks

Reply to this Message