sendmail macro

[Benoit]

Hello,

I'm using the following command in a macro:

ActiveWorkbook.sendmail "[email protected]", "Lists for
today."
ActiveWorkbook.sendmail "[email protected]", "Lists for
today."
ActiveWorkbook.sendmail "[email protected]", "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("[email protected]", "[email protected]"), _
"This is the Subject line"

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