Email Alert when cell triggers red (low stock)

[R1_Canuck]

Hi All

I would like an email alert to be sent to a select group of people when the closing stock on a sheet is marked red (marked using conditional formatting that is already in place).

It is a simple sheet, but Im not sure on the VBA to make this happen. If it is able to send the email alert when the sheet is closed that would be ideal, but Im not sure if this is possible?

The email alert needs to be per product, so e.g. "POTASSIUM NITRATE IS LOW - LOOK TO ORDER".

Sheet is attached!

Many thanks in advance.

R1

[antoka05]

You could use this code that runs when you close the workbook:
Right click, in the bottom, on the tab with sheet name, choose view code, on the left click on ThisWorkbook and on the right window paste the code.
Then on the menu choose Tools, reference and choose 'Microsoft Outlook xx.x Object Library'.

Please Login or Register  to view this content.

Regards,
Antonio