View Single Post
  #3   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 read a response to a similar post in this forum. I assign the multiple
addresses to an array and pass the array (array()) to .SendMail in the
Recipients slot. Thanks.

"Ron de Bruin" wrote:

Hi Chaplain

See
http://www.rondebruin.nl/mail/tips1.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Chaplain Doug" wrote in message ...
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.