Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mutiple names in ActiveWorkbook.SendMail Recipients:= | Excel Discussion (Misc queries) | |||
Autorecover: Unexpected Error message recipients unite... | Excel Discussion (Misc queries) | |||
sendmail error | Excel Programming | |||
Multiple Recipients in SendMail Method. HELP!!! | Excel Programming | |||
Multiple Recipients | Excel Programming |