SendMailReminder

Hi guys,

I want to send automatic emails (even when the sheet is closed) whenever stock is low. I've had an attempt but I think I am barking up the wrong tree.

This macro cannot tell the difference whether or not the stock is low and it requires someone to run it. I am aware I can do this with a command button, but this is not acceptable; also, it will send the email reminder regardless of the conditional formatting. How can I make it see the difference and run it automatically.

HTML Code: 

Any help is appreciated. My end goal is for an automatic email to be sent to two people when any stock is low. The spreadsheet is attached, only two tabs are ready with all of the correct info and the conditional formatting already in place (JANUARY & JULY).

Thanks a lot,

Henry