SendMail method - multiple recipients 2

[Dabase]

Hi,

I am trying to use the SendMail method in VBA to send a workbook to various email addresses, but I am not having any luck with it.

When sending to one email address this works successfully:

ActiveWorkbook.SendMail ("someone@somedomain.com")

Any help on this would be greatly appreciated.

Thanks
Dabase

 

[PHV]

Have you tried something like this ?
Dim myArr(2) As String
myArr(0) = "someone@somedomain.com"
myArr(1) = "sometwo@anotherdomain.com"
myArr(2) = "ghost@unknowndomain.com"
ActiveWorkbook.SendMail myArr

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Dabase]

Hi PHV,

Just a quick note to say thanks.

I tried your suggestion and it worked.



Thanks
Dabase