| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Email code | Excel Worksheet Functions | |||
| Need help with email code (PLEASE) | Excel Programming | |||
| Need help with Email Code (PLEASE) | Excel Worksheet Functions | |||
| Email VBA Code | Excel Programming | |||
| VBA Code for Email | Excel Programming | |||
![Mary[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
