SendMail Multiple Recipients

  • Thread starter Thread starter Thore
  • Start date Start date
T

Thore

Hello all,

How does the macro code look for sending a mail to
multiple recipients and a subject?
The SendMail Method Example in VB Help could be a bit more
detailed...

Thanks in advance,
Thore
 
Hi Thore

Look at the examples on my site
http://www.rondebruin.nl/sendmail.htm


Send the mail to more people.

..SendMail Array("(e-mail address removed)", "(e-mail address removed)"), _
"This is the Subject line"

Send to all E-mail addresses in a range

Dim MyArr As Variant
MyArr = Sheets("mysheet").Range("C1:C10")
..SendMail MyArr, "This is the Subject line"
 
Back
Top