adjust .Sendmail for mutiple recipients on internal email network

J

J.W. Aldridge

Hi.
I am using Ron's Sub Mail_ActiveSheet() code and it seemingly works
fine with one addressee, but when using several, it takes forever to
send and then the recipients never seem to get it.

I am only sending emails to those who are in my network so I dont want
to type in the email extensions ([email protected]). I only want to
state their first (space) then last name. How do I adjust this code to
get this done?

Thanx

(My Code below)


With Destwb
.SaveAs TempFilePath & TempFileName & FileExtStr,
FileFormat:=FileFormatNum
On Error Resume Next
.SendMail "Jeremy W. Aldridge; John Doe; Jane Doe; Mama Doe;
Papa Doe", _
"Mindex Daily - Hourly Performance Recap"
On Error GoTo 0
.Close SaveChanges:=False
End With
 
T

Tom Ogilvy

to any potential respondents,
this question has been answered in another thread
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top