VBA code to CC email
 

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

VBA code to CC email
 

Mary

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
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" wrote in message
...
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

VBA code to CC email
 

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

thanks anyway.

"Nick Hodge"
...
Mary

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
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" wrote in message
...
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

VBA code to CC email
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mary" wrote in message ...
coz some recipients would like to "cc" instead of "to".

thanks anyway.

"Nick Hodge"
...
Mary

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
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" wrote in message
...
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