sendmail macro

[Benoit]

Hello,

I'm using the following command in a macro:

ActiveWorkbook.sendmail "(e-mail address removed)", "Lists for
today."
ActiveWorkbook.sendmail "(e-mail address removed)", "Lists for
today."
ActiveWorkbook.sendmail "(e-mail address removed)", "Lists for
today."

I would like to know if it's possible to send the document
to all 3 addresses at one time (cause by using the
commands I'm using above, 3 emails are sent).

Thanks!!!

 

[Ron de Bruin]

You can use a array

For mailing to more people use this line.
..SendMail Array("(e-mail address removed)", "(e-mail address removed)"), _
"This is the Subject line"

Check out my site for more examples
http://www.rondebruin.nl/sendmail.htm