Send an email if the value of the cell is zero

[chunkyp]

I have a worksheet which contains several columns. The 2 columns that are of importance here are Column AB and AD.
Column AB contains formulas and Column AD contains email addresses. Is there a way where if the value of a row in column AB is 0 then when I click on the email button all the rows with the value 0 will have an email sent from outlook asking to send in their data?

[bakerman2]

Let's start with this.

Please Login or Register  to view this content.

[Sintek]

Hi bakerman2.....Any chance of storing the recipients email addresses in an array during the loop and after the loop completes, then send off one email to all at once....
Something like:

Please Login or Register  to view this content.

[Sintek]

Perhaps like such?....please excuse the use of your code...Hope it's right.

Please Login or Register  to view this content.

EDITED: Extra code applied from Warship

[chunkyp]

Thank you @bakerman2 and @sintek for your contribution.

[Sintek]

Glad I could contribute...thanks fro rep point added

[bakerman2]

You're welcome and thanks for rep+.

@ sintek
If the mail doesn't need to be personalized you it's indeed better to do it the way you suggested.