.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....

.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....

.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

.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.....