Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to send email to multiple recipients using VBA?

  Asked By: Bonni    Date: Aug 12    Category: MS Office    Views: 6581
  

I was trying to use the following to send an excel file to someone
and it worked:

ActiveWorkbook.SendMail Recipients:="aaa@..."

I wonder, if I want to send to more than just one recipient, for
instance, if I also want to cc "bbb@...", how shall I write
the code?

I tried the following two but didn't work.

Recipients:="aaa@..." "bbb@..."
Recipients:="aaa@...","bbb@..."

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Allison Stanley     Answered On: Aug 12

Like this:

ActiveWorkbook.SendMail Recipients:=Array("aaa@...",
"BBB@...")

 
Didn't find what you were looking for? Find more on How to send email to multiple recipients using VBA? Or get search suggestion and latest updates.




Tagged: