Automatically send email after certain condition is met

[aglasier]

Hello all!

You guys were amazing with my last question so hopefully I could get some additional help once again!

Below is a screenshot of a page that if possible I would like to have the ability to automatically send a notification email when stock goes yellow and another when it goes red. Not sure if you can tie it to the color so if not send the emails during specific ranges, lets say 1 email to 2 addresses if stock is between 20,000 - 40,000 and then another email to 3 addresses if under 20,000.

First I'm wondering if this is possible without VBA, there are so many features I have yet to discover in Excel so there may be something. If I need VBA then how do I go about doing this?

Capture.JPG

Thanks in advance for any help!
Allan

[Richard Buttrey]

Sending an eMail is the easy bit but you will need VBA.

In order to kick off a a VBA macro you will need to use a Worksheet Change event. i.e. one that runs whenever something changes on a sheet. In your case that would be any cell that when changed causes a change in the Quantity column.

Without seeing the workbook it's not possible to advise further so uploading the workbook should be your next step.

[aglasier]

Thank you for the reply Richard!

My workbook has somewhat sensitive information in it so do you mind if I send it to you in a private message?

[Richard Buttrey]

In that case desensitise the data and upload the workbook. We don't mind how many Donald Duck, M. Mouse...etc names you include.

[aglasier]

That is a much better idea lol

Attached file.

[jcvil]

Did you ever figure out the code for this? I'm curious.