Carbon Copies in Email Merge

[fgwiii]

I have found several posts about including carbon copies
to multiple recipients, but I have been unable to find an
relevant information in the MVP post:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.ht
m

Would someone please give me a hand here?

Thanks, fgwiii

 

[Doug Robbins]

After declaring myccrecipient as Recipient, use the following in the code
after the .To statement

Set myccrecipient = .Recipients.Add("CC Recipient")
myccrecipient.Type = olCC

For more details, see the VB help file for CC (you will need to have set
the reference to the Outlook Object library)

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[fgwiii]

While I am certainly willing to take a stab at this, can you give me a little
direction at this? I am not a programmer. Would you please be a little more
specific?

Thanks

Fred

 

[Doug Robbins]

I am not a programmer either and all that I know about visual basic has been
learned by reference to the Visual Basic Help file and trial and error.

At the beginning of the code you will need a

Dim myccrecipient as Recipient

and then in the code after the .To statement, you will need to insert

Set myccrecipient = .Recipients.Add("CC Recipient")
myccrecipient.Type = olCC

In place of "CC Recipient" you would place the email address of the party to
whom the CC is to be sent.
--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP