VBA Send Email from Excel (almost complete)

Hi all,


I have the attached doc which is almost complete i need the following help

1, need the VBA to look in column H and where it is blank then send email to the email in B (this bit is working and what is in the email etc is done)
2,I need it so it doesn't stop at row 3 which it currently does.

All help would be amazing!!!confused:

Looking in your code, you have the following:

Please Login or Register  to view this content.

Which is why it would be stopping - you need to set a variable to count the number of used rows and call

Please Login or Register  to view this content.

Hi thank you for the above so how do i go about that?

Here is your new code:

Please Login or Register  to view this content.

First thing that is perfect and worked like a dream but how do i get it to check if there is a YES in Column H first adn if a yes no email is sent if blank then send email? Thank you for your help.

estratosphere,

Nice code. FYI you missed a comma in the line

Please Login or Register  to view this content.

Regards,

BigDawg15

I did the notice it come up red but luckily I worked the comma out lol Any ideas on the if question above?

Here you go.

Please Login or Register  to view this content.

Originally Posted by BigDawg15

estratosphere,

Nice code. FYI you missed a comma in the line

Please Login or Register  to view this content.

Regards,

BigDawg15

Whoops! Thanks for the spot!