View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default Error with Multiple Recipients on .SendMail

I am getting an error when using multiple email addresses in the .SendMail
method. When for instance Recipients is ; person2@xyz,net"
in the following line:

Wb.SendMail Recipients, Subject + " " + Wb.Name, True

I get the message:

Runtime Error '1004'
Unknown recipient name found in recipient list. Use valid name and try again.

The names (addresses) I am usgin are valid. And the command works with just
one recipient. It is when I specify two recipients that I get the error.
Thanks for the help.