MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

SendMail error with multiple recipients

  Asked By: Clifford    Date: Jan 11    Category: MS Office    Views: 1958

The following code worked well with just one recipient:
ActiveWorkbook.SendMail Recipients:="name.surname@...",
Subject:="File: " & Export_File_Name

Adding a second recipient kills it, though. I am not able to figure out
the correct format. I have tried:
ActiveWorkbook.SendMail Recipients:="name.surname@..." & ";"
& "name2.surname2@...", Subject:="File: " & Export_File_Name

And also
ActiveWorkbook.SendMail Recipients:="name.surname@...;
name2.surname2@...", Subject:="File: " & Export_File_Name

Thanks in advance for your help.



5 Answers Found

Answer #1    Answered By: Sammy Brown     Answered On: Jan 11

What specifically do you mean by "kills it"? What exactly happens?

Answer #2    Answered By: Archer Smith     Answered On: Jan 11

I guess you have to specify the Receipients as an array

Activeworkbook.SendMail Receipients:=

Answer #3    Answered By: Ida Andrews     Answered On: Jan 11

Some vague memory tells me you may need a comma instead of the semicolon.

Answer #4    Answered By: Lionel Thomas     Answered On: Jan 11

Try this, it worked for me:

ActiveWorkbook.SendMail Recipients:=Array
("someone@...", "person2@...")

Answer #5    Answered By: Alejandro Smith     Answered On: Jan 11

Thank you all for your responses. Array works like a charm.

Didn't find what you were looking for? Find more on SendMail error with multiple recipients Or get search suggestion and latest updates.