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

ActiveWorkbook.SendMail "; ";
, "Today's Report"

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 :

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

ActiveWorkbook.SendMail "; ";
, "Today's Report"

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



"Franck" wrote in message oups.com...
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 :

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

ActiveWorkbook.SendMail "; ";
, "Today's Report"