Sending e-mail through VBA

[MarianneBal]

Dear All,

I have created following:

Please Login or Register  to view this content.

The email addresses are locate at the range mentioned below, but Excel would only send the email when I enter ...Range("b2")
But it doesn't send it to the other recipients.

MyArr1 = Sheets("Recipients").Range("b2:b4")
MyArr2 = Sheets("Recipients").Range("c2:c10")

Please can anybody help me and tell me what I'm doing wrong?? Why isn't it working for the whole range?

I've also tried naming the range etc...

Please help!!!!

[Domski]

Hi,

Please take a moment to read the forum rules and edit your post to include code tags.

Dom

[MarianneBal]

Thanks Dom!!!

[Domski]

Thanks. This may work:

Please Login or Register  to view this content.

Dom

[MarianneBal]

YES!!!! Thank you Dom, it works! You're my saviour!

[Brains1960]

When i try its sayas it cant create the outlook.apllication

[JosephP]

does it work if you start outlook before running the code?