Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email to multiple users via excel
Hi All,
I had write a code to send an email via Outlook, just to one person. My question: How can I send it to multiple persons like: To: email1; email2; etc. and Cc: email1; email2; etc. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
email to multiple users via excel
Hi P,
See Ron De Bruin's Sendmail page for a wide selection of email code: http://www.rondebruin.nl/sendmail.htm Perhaps the following will help you: http://www.rondebruin.nl/mail/folder2/files.htm --- Regards, Norman "p. panter" wrote in message ... Hi All, I had write a code to send an email via Outlook, just to one person. My question: How can I send it to multiple persons like: To: email1; email2; etc. and Cc: email1; email2; etc. Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
email to multiple users via excel
You can check Ron de Bruin's site:
Send text in the body of the mail with Outlook Express http://www.rondebruin.nl/mail/oebody.htm I think the procedures are the same for Outlook and for Outlook Express Basically you are creating a hyperlink and if you look at his code you will see the basic structure if you look at several lines together with HLINK The trickiest part in setting up is make the substitutions for line breaks, ampersands, and spaces in the appropriate places. With a little care you could do the same thing in HTML, or any other hyperlink, or a mailing like you are asking for or even separate emails. Sometimes you want to send out blind copies but certain ISPs tend to block blind copies so individual emails might be preferable. Anyway see Ron's site. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "p. panter" wrote in message ... Hi All, I had write a code to send an email via Outlook, just to one person. My question: How can I send it to multiple persons like: To: email1; email2; etc. and Cc: email1; email2; etc. Thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
email to multiple users via excel
Hi
Do you use SendMail or the Outlook object model to send the mail ? On my site there are examples for both and if you press on the Tip link on the pages you will find your answer -- Regards Ron de Bruin http://www.rondebruin.nl "p. panter" wrote in message ... Hi All, I had write a code to send an email via Outlook, just to one person. My question: How can I send it to multiple persons like: To: email1; email2; etc. and Cc: email1; email2; etc. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - button to email selected users. | Excel Discussion (Misc queries) | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
Excel 2007 time schedule for non Excel users to fill in and email | Excel Discussion (Misc queries) | |||
allow multiple users on excel spreadsheet | Excel Worksheet Functions | |||
Can Excel support Multiple Users | Excel Programming |