Mail merge with CC and BCC recipients

[emina002]

Is there any way to create or enable rather a CC recipient of mail merge inside MS Word, It seems that MS Publisher only have this feature but it seems the client doesn't want to use MS Publisher since he is not familiar on how to use it. I hope someone could give a sample vba code to enable this problem. Thanks

[macropod]

Word mailmerges to email do not support the CC & BCC options. To use those, you'd need to use a macro to automate Outlook. The alternative is to use separate mailmerges to generate something comparable to the CC & BCC outputs, using the same data source but different destination fields for the addressees.

[emina002]

So is there possibility to use mail merge on outlook using excel workbook as a source?. I am planning that also as an alternative to achieve this project.

[macropod]

AFAIK an Outlook-driven mailmerge requires all the recipients to be in your contacts folder. It also uses Word, so I doubt you'd do any better with that vis-a-vis CC & BCC.