auto e-mail to numerous people

[Guest]

I'm using this code in an exisitng macro to auto send the workbook to
(e-mail address removed), however when I add additional e-mail addresses as shown
below, it won't work, any idea what I'm doing wrong?

ActiveWorkbook.SendMail "(e-mail address removed)"; "(e-mail address removed)";
"(e-mail address removed), "Today's Report"

 

[Franck]

I was typing the code but easier to post the link and it save space on
google servers

http://j-walk.com/ss/excel/tips/tip86.htm


JOUIOUI a écrit :

 

[Ron de Bruin]

Have you change the loop numbers
For r = 2 To 4 'data in rows 2-4

You can also use this example based on John's example
http://www.rondebruin.nl/mail/oebody.htm

Example 3 on that page


--
Regards Ron de Bruin
http://www.rondebruin.nl



I was typing the code but easier to post the link and it save space on
google servers

http://j-walk.com/ss/excel/tips/tip86.htm


JOUIOUI a écrit :