Multiple SendMail Recipients

[Guest]

Is it possible to have more than one recipient with the SendMail Method?

I know I can do this: ActiveWorkbook.SendMail
Recipients:=("(e-mail address removed)").
But I haven't figured out how to add a second email address. Is it
possible? Or do you need to use a second SendMail line?

 

[Bob Phillips]

You can setup an array of names as the recipient list

ActiveWorkbook.SendMail _
Recipients:=Array("(e-mail address removed)", "(e-mail address removed)"), _
Subject:="test"

 

[Guest]

Thanks, that did the trick!

You can setup an array of names as the recipient list

ActiveWorkbook.SendMail _
Recipients:=Array("(e-mail address removed)", "(e-mail address removed)"), _
Subject:="test"