| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Emailing Worksheet - adding muliple reciepients
Hello,
I am using Ron's code in order to attached a worksheet to an email and send it out. Now, in the same workbook that the worksheet is (the one I am emailing out), there is a worksheet called "Data" which houses the email addresses of all the people I would like to send the email to. The list is in Column A - starting Row 1 and the list continues to be added to. Each email address is in its own cell. How do I incorporate some code to collect all of the email addresses and put them in the ".to = xxxxxxx"? I only want to sent one email to all of the receipents. Any assistance would be appreciated. Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing Worksheet - adding muliple reciepients
Click on the link to the Tip page that you find on each example page.
There is a example there to do what you want -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike R." <Mike wrote in message ... Hello, I am using Ron's code in order to attached a worksheet to an email and send it out. Now, in the same workbook that the worksheet is (the one I am emailing out), there is a worksheet called "Data" which houses the email addresses of all the people I would like to send the email to. The list is in Column A - starting Row 1 and the list continues to be added to. Each email address is in its own cell. How do I incorporate some code to collect all of the email addresses and put them in the ".to = xxxxxxx"? I only want to sent one email to all of the receipents. Any assistance would be appreciated. Mike __________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing Worksheet - adding muliple reciepients
Hi Ron,
Thank you for the response. I have searched your website high and low, but I can not seem to locate what I am looking for. Any assistance would be great. Thank you, "Ron de Bruin" wrote: Click on the link to the Tip page that you find on each example page. There is a example there to do what you want -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike R." <Mike wrote in message ... Hello, I am using Ron's code in order to attached a worksheet to an email and send it out. Now, in the same workbook that the worksheet is (the one I am emailing out), there is a worksheet called "Data" which houses the email addresses of all the people I would like to send the email to. The list is in Column A - starting Row 1 and the list continues to be added to. Each email address is in its own cell. How do I incorporate some code to collect all of the email addresses and put them in the ".to = xxxxxxx"? I only want to sent one email to all of the receipents. Any assistance would be appreciated. Mike __________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Emailing Worksheet - adding muliple reciepients
If you want to change the Outlook object model examples from my site see this tips page.
http://www.rondebruin.nl/mail/tips2.htm For SendMail http://www.rondebruin.nl/mail/tips2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike R." wrote in message ... Hi Ron, Thank you for the response. I have searched your website high and low, but I can not seem to locate what I am looking for. Any assistance would be great. Thank you, "Ron de Bruin" wrote: Click on the link to the Tip page that you find on each example page. There is a example there to do what you want -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike R." <Mike wrote in message ... Hello, I am using Ron's code in order to attached a worksheet to an email and send it out. Now, in the same workbook that the worksheet is (the one I am emailing out), there is a worksheet called "Data" which houses the email addresses of all the people I would like to send the email to. The list is in Column A - starting Row 1 and the list continues to be added to. Each email address is in its own cell. How do I incorporate some code to collect all of the email addresses and put them in the ".to = xxxxxxx"? I only want to sent one email to all of the receipents. Any assistance would be appreciated. Mike __________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3950 (20090320) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3950 (20090320) __________ The message was checked by ESET Smart Security. http://www.eset.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding subject when emailing with macro | Excel Worksheet Functions | |||
| Muliple Worksheet Lookup | Excel Worksheet Functions | |||
| How to link a Worksheet for viewing, for muliple recepients? | New Users to Excel | |||
| Adding muliple cells. | Excel Worksheet Functions | |||
| Adding muliple cells. | Excel Worksheet Functions | |||
![Mike R.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
