Multiple Recipients in SendMail Method. HELP!!!

[John Baker]

Hi:

I have been automatically sending an e mail from my Excel for some time, using the
following statement:

ActiveWorkbook.SendMail recipients "(e-mail address removed)", _
etitle

I am not attempting to add another recipient, and am having a difficult time. The "Help"
on sendmail says the following:

"Recipients Required Variant. Specifies the name of the recipient as text, or as an
array of text strings if there are multiple recipients. At least one recipient must be
specified, and all recipients are added as To recipients."

It refers to "an array of text strings", but i cant appear to set up an array that is
acceptable and will work.
I have tried:
ActiveWorkbook.SendMail "(e-mail address removed)", _
etitle

a) ActiveWorkbook.SendMail "(e-mail address removed), (e-mail address removed)", _
etitle
b) ActiveWorkbook.SendMail "(e-mail address removed),""(e-mail address removed)",_
etitle
c)ActiveWorkbook.SendMail "(e-mail address removed) (e-mail address removed)", _
etitle

None of them work! Either the compiler does not like them or Outlook does not..

Can someone tell me the right way to set this up please?

Regards

John Baker

 

[Daniel Klann]

Hi John,

ActiveWorkbook.SendMail Array("(e-mail address removed)", "(e-mail address removed)")

Should work for you.

Regards,
Dan

 

[John Baker]

Dan:

Thank you very much. Its amazing how many times the good folks on this and other
Newsgroups have helped me with something that I was totally stumped on.

Regards

John Baker

 

[cpgscoord]

ActiveWorkbook.SendMail Array:=("(e-mail address removed)","(e-mail address removed)"), _
Subject:="In House Function Sheet"

gives me the error of

Complie Error Expected: )