[RESOLVED] Mail Merge and CC problem

[Resource Dragon]

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.

[Resource Dragon]

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.)