Multiple SendMail Recipients

J

John Hutcins

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?
 
B

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"
 
J

John Hutcins

Thanks, that did the trick!

Bob Phillips said:
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top