Want to include CC and BCC in Mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aniruddha - 14 May 2004 09:46 GMT

Hellow everybody

For quite some time have been searching for some ways to send BCC and CC through the Mail merge utility of MS Word 2003. I have prepared a data file in hich I have store

1) Address where the mail will have to go .( TO )
2) Address where it will be marked as carbon copy. ( CC
3) Name of the person whom it intends to reach ( Name
4) Name of the person whom carbon copy intends to reach ( CCName
Same for BC
Now , Mail merrge does send the mail to address in filed TO , but I could not manage to get that going to CC and BCC.

Please help urgently
Regards
Aniruddh

Reply to this Message

Doug Robbins - Word MVP - 14 May 2004 13:37 GMT

You can modify the procedure in the article "Mail Merge to E-mail with
Attachments" at

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

to do that. In the Catlog or Directory type mailmerge that is created,
include columns for the CC and BCC mailmerge addresses and grab hold of them
in the same way that the To address is obtained. Then you use

.To = Datarange
'code to get CC email address into Datarange
.CC = Datarange
'code to get BCC email address into Datarange
.BCC = Datarange

Or, if the CC and the BCC do not change, you could either hard code them
into the macro.

You do not have to have attachments to send with the email, it's just a way
of splitting up the document and mailing each letter to a different address.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hellow everybody,
>
> For quite some time have been searching for some ways to send BCC and CC through the Mail merge utility of MS Word 2003. I have prepared a data file

in hich I have stored

> 1) Address where the mail will have to go .( TO )
> 2) Address where it will be marked as carbon copy. ( CC )
[quoted text clipped - 6 lines]
> Regards.
> Aniruddha

Reply to this Message