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"