Emailing Worksheet - adding muliple reciepients

  • Thread starter Thread starter Mike R.
  • Start date Start date
M

Mike R.

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
 
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. said:
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
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 3947 (20090319) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
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,
 
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. said:
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,




__________ Information from ESET Smart Security, version of virus signature database 3950 (20090320) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 3950 (20090320) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Email specific fields in a worksheet 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
VBA code to email 1 worksheet in a workbook 2
Access Automatically Send a notification email once a record is added 0
Email Bounce Error 3
Rows To Columns & Hyperlink to Email Address 0
Outlook Macro - Help Required 0
send email to email address in column 2

Back
Top