ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error with Multiple Recipients on .SendMail (https://www.excelbanter.com/excel-programming/319632-error-multiple-recipients-sendmail.html)

Chaplain Doug

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.



Ron de Bruin

Error with Multiple Recipients on .SendMail
 
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.





Chaplain Doug

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.







All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com