Sending Attachments to multiple recipients

[Guest]

Hi, back again.
Q1. Any advice how to include more that one recipient when sending
attachments from excel?

Q2. Also, I am aware that (Copy to and (Body Text) is not possible in
Outlook. I am however, using Eurora and was wondering, perhaps there was a
way to perform this.

The code I've used is:

With Workbooks("dreams.xls")
.SendMail Recipients:="(e-mail address removed)", Subject:="Dreamer"
End With

Many thanks in advance
Prabha

 

[Don Guillett]

try just adding a comma and put the next one in. OR, if you have a group set
up in your address book, try sending to that group name????

 

[Guest]

Dear Don,
Many thanks for the quick response, however, having done as you've
instructed by adding a comma and including the next address, I get the
following error message:

Compile Error: Expected Named Parameter!!

With regards to a Group Address, Eudora is scratching it's head as it seems
to be confused!!
Regards,
Prabha

 

[Guest]

It is possible your email program requires a semicolon between addresses, e.g.:

.SendMail
Recipients:="(e-mail address removed)";"(e-mail address removed)";"(e-mail address removed)", Subject:="Dreamer"

HTH