Mail Merge with option for multiple carbon copy (cc)

[ManuPant]

Hello All,

I have a requirement where I have to send separate email to 150 recipients (each email has 1 person in To and 2 email id's in cc). Also, the user name in salutation is same as the To person.
So far I have explored option of mail merge and I am able to send emails as desired through the use of word+excel and outlook. However, the problem is that I am not able to add the cc.

I have understood that a vb code will be required to add the cc in each email.

Can anybody help me with the code here. I am not into macros at all and thus it is a blocker for me at this point.

 

[CalcSux78]

Welcome to the forum! There are many ways to accomplish this. Would you mind posting an example of how your data is laid out? (Since your data is most likely confidential, make a sample sheet with some generic names and addresses)

Here's a link for HTML Maker (used for posting a portion of your spreadsheet to posts) http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2545970


In the mean time, Ron de Bruin has some wonderful tutorials on emailing from Excel: Mail from Excel with Outlook (VBA)