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