Multiple Recipients

Luis Rentería · Dec 2, 2003

Hi!

How can I set multiple recipients using the SendMail Method?

Currently, I'm using the following code, but at the end, only user1 receives
the email.

ActiveWorkbook.SendMail Recipients:="[email protected], [email protected]"

Thanks in advance.

Chip Pearson · Dec 2, 2003

Luis,

Put the recipients in an array. E.g.,

ActiveWorkbook.SendMail
Recipients:=Array("[email protected]","[email protected]")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Multiple Recipients

Luis Rentería

Chip Pearson