help with VBA conditional notification emails

I am new to VBA coding and I have tried to figure this out but my head is starting to hurt so I thought I would ask for help. I want excel to automatically send an email to multiple recipients when the formula in R26 finds the information that meets the correct criteria and populates with data but not when it goes back to an unpopulated cell. I have found a lot of different codes that send different types of emails but I am having a hard time figuring out what each line does and I am not sure how to adapt it to what I want.

that meets the correct criteria and populates with data but not when it goes back to an unpopulated cell.

Does the macro need to check the data for accuracy prior to sending the email/s ... or, can the email/s be sent anytime the cell has data within ?

Please Login or Register  to view this content.

Thank you so much for your help. I will try it out the next time I go in to work

alright so I put in the code but nothing happened I tried F5 and ALT+F8 but the option to select it was not there am I missing something?

The macro goes in the Sheet level module. Do not paste it into a Regular module.

Then, when R26 changes from BLANK to anything, the email macro fires.