Multiple SendMail Recipients

[John Hutcins]

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

I know I can do this: ActiveWorkbook.SendMail
Recipients:=("***@Addr.com").
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("***@Addr.com", "***@somewhere.com"), _
Subject:="test"
--
HTH

Bob Phillips

Post by John Hutcins
Is it possible to have more than one recipient with the SendMail Method?
I know I can do this: ActiveWorkbook.SendMail
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?

[John Hutcins]

Thanks, that did the trick!

Post by Bob Phillips
You can setup an array of names as the recipient list
ActiveWorkbook.SendMail _
Subject:="test"
--
HTH
Bob Phillips

Post by John Hutcins
Is it possible to have more than one recipient with the SendMail Method?
I know I can do this: ActiveWorkbook.SendMail
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?