VBA code to CC email

[Mary]

Dear Expert

knowing that can use the code "sendmail" to send email to some certain mail
addresses. But if it is possible (or any other VBA codes) to "CC" the mail
to the other mail addresses in the same mail? Thanks.

Mary

 

[Nick Hodge]

Mary

I think they will all be counted as recipients (so to: not cc

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[Mary]

coz some recipients would like to "cc" instead of "to".

thanks anyway.

 

[Ron de Bruin]

Hi Mary

If you use Outlook you can use the Outlook object model code from my site.
If not see the CDO code on my site
http://www.rondebruin.nl/sendmail.htm