Email

P

PBANKS

Is there a way to email more than one person in one line of code?


This is the way that I have it now:
ActiveWorkbook.SendMail Recipients:="pbanks"

And this did not work:
ActiveWorkbook.SendMail Recipients:="pbanks & pbanks"

Nor did:
ActiveWorkbook.SendMail Recipients:="pbanks;pbanks"

Any ideas?
 
D

Dave Peterson

ActiveWorkbook.SendMail Recipients:=array("pbanks","pbanks")

(the same person twice???)
 
P

PBANKS

Just testing, do not want the people that will be getting these sheets
to get confused (like me) thanks, I will try this.
 

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

Similar Threads

Macro to send an email automatically 1
Sending Excel Workbooks to Outlook people automatically 1
Insert name and adress from a list in a word document 1
Use Bcc 3
Sending mail 5
ActiveWorkbook.SendMail Recipients 2
.SendMail Method into Eudora 0
ActiveWorkbook.SendMail and IE - odd problem 0

Top