[RESOLVED] Mail Merge and CC problem
G’day. Does anyone have a solution to the following mail merge problem?
I have created a mail merge using Word 2003 and Excel 2003 (for the data source) and the completed product is sent via Outlook. The problem is that I want to CC each e-mail to two or three people. The Microsoft people obviously designed mail-merge thinking in terms of “personalized” mass mail-outs and so they don’t offer a CC option.
The interim solution that I am using is putting all three recipients’ e-mail addresses in the To field but this is not elegant.
So, can I do something cunning with VBA to force a CC option? Is there some other cunning solution to this problem?
Thanks.
Re: Mail Merge and CC problem
Since posting this question I have found a solution using VBA and not using mail-merge. (Mail merge had some other disadvantages for that particular project.)