| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple SendMail Recipients
Is it possible to have more than one recipient with the SendMail Method?
I know I can do this: ActiveWorkbook.SendMail "). But I haven't figured out how to add a second email address. Is it possible? Or do you need to use a second SendMail line? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple SendMail Recipients
You can setup an array of names as the recipient list
ActiveWorkbook.SendMail _ ", "), _ Subject:="test" -- HTH Bob Phillips "John Hutcins" wrote in message ... Is it possible to have more than one recipient with the SendMail Method? I know I can do this: ActiveWorkbook.SendMail "). But I haven't figured out how to add a second email address. Is it possible? Or do you need to use a second SendMail line? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple SendMail Recipients
Thanks, that did the trick!
"Bob Phillips" wrote: You can setup an array of names as the recipient list ActiveWorkbook.SendMail _ ", "), _ Subject:="test" -- HTH Bob Phillips "John Hutcins" wrote in message ... Is it possible to have more than one recipient with the SendMail Method? I know I can do this: ActiveWorkbook.SendMail "). But I haven't figured out how to add a second email address. Is it possible? Or do you need to use a second SendMail line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mutiple names in ActiveWorkbook.SendMail Recipients:= | Excel Discussion (Misc queries) | |||
| Email Hyperlink Multiple Recipients | Excel Discussion (Misc queries) | |||
| Error with Multiple Recipients on .SendMail | Excel Programming | |||
| Multiple Recipients in SendMail Method. HELP!!! | Excel Programming | |||
| Multiple Recipients | Excel Programming | |||
Linear Mode
