| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.Sendmail to Multiple Internal Addresses
Using Ron's code:
Sub Mail_ActiveSheet() Currently set to send to full email address(es). Need to send to internal email address names...(whole names only without extensions). Tried several methods, nothing worked so far.... ..SendMail @somewhere. ", _ ' "EMail Subject" WHAT'S NEEDED.... ..SendMail "Jeremy Aldridge;Jane Doe;Julie Doe", _ ' "EMail Subject" thanx.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.Sendmail to Multiple Internal Addresses
.SendMail Array("Jeremy Aldridge","Jane Doe","Julie Doe"), _
"EMail Subject" If Jeremay Aldridge would work as a single address, then I believe the above is what you need. -- Regards, Tom Ogilvy "J.W. Aldridge" wrote: Using Ron's code: Sub Mail_ActiveSheet() Currently set to send to full email address(es). Need to send to internal email address names...(whole names only without extensions). Tried several methods, nothing worked so far.... ..SendMail @somewhere. ", _ ' "EMail Subject" WHAT'S NEEDED.... ..SendMail "Jeremy Aldridge;Jane Doe;Julie Doe", _ ' "EMail Subject" thanx.... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.Sendmail to Multiple Internal Addresses
..sendmail ", _
", _ "), _ "email subject" "J.W. Aldridge" wrote: Using Ron's code: Sub Mail_ActiveSheet() Currently set to send to full email address(es). Need to send to internal email address names...(whole names only without extensions). Tried several methods, nothing worked so far.... .SendMail @somewhere. ", _ ' "EMail Subject" WHAT'S NEEDED.... .SendMail "Jeremy Aldridge;Jane Doe;Julie Doe", _ ' "EMail Subject" thanx.... -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
.Sendmail to Multiple Internal Addresses
Thank both you guys!
Worked purrfectly! I'm buying you both Krystal burgers (or White Castle) WITH CHEESE when I become a millionaire soon..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adjust .Sendmail for mutiple recipients on internal email network | Excel Programming | |||
| Multiple SendMail Recipients | Excel Programming | |||
| Error with Multiple Recipients on .SendMail | Excel Programming | |||
| Sending multiple emails using SendMail | Excel Programming | |||
| Multiple Recipients in SendMail Method. HELP!!! | Excel Programming | |||
Linear Mode
