I'm using this code in an exisitng macro to auto send the workbook to
(E-Mail 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 Removed)"; "(E-Mail Removed)";
"(E-Mail Removed), "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
> (E-Mail 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 Removed)"; "(E-Mail Removed)";
> "(E-Mail Removed), "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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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
> (E-Mail 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 Removed)"; "(E-Mail Removed)";
> "(E-Mail Removed), "Today's Report"