Send email when criteria is met

[ball32]

Hi there,

This is my first post so I would like to take an opportunity and say hello to everybody.
I'm working on one file which should send alert when criteria is met and insert chart in to the outlook body. I have the code for it but there is a problem. For example when value in cell A1 reaches let's say 70% it sends email. The problem is that when any other values are being changed it keeps sending emails even if value in cell A1 is not changing. I'm using Worksheet_calculate event for it. Also I can't figure out how to insert only the chart in the email body, currently I'm selecting the range where the chart is and doing it this way, but the chart is not looking good in the email.
I'm attaching the sheet hopefully it will make more seance.
Worksheet_calculate event is in sheet "Email list"
Code for sending email is in module3

Hope I explained this good enough.
Thank you

[AlphaFrog]

Hi and welcome to the forum.

Try something like this to trigger the emails. Each time it calculates, the calculated Max is compared to the stored max in cell G8. If it's different, the new calculated max is stored in G8 and runs your AlertS macro.

Please Login or Register  to view this content.

The chart looks fine to me in the email. Another method could be to store the Chart as an image and put the Chart-Image within the email. Here's a link with example code...
Mail chart or chart sheet as picture

[ball32]

Thanks for that, it does what I asked for, but I forgot to mention one thing, sorry for being idiot. In the "email list" sheet is 4 different values 70%, 80%, 90% and 100%. when the "MAX" reaching these numbers I need to trier alerts. so for example when it reaches 70% email will be send to one person, when it reaches 80 it will send it to different person up until 100%.

[AlphaFrog]

Thanks for that, it does what I asked for, but I forgot to mention one thing, sorry for being idiot. In the "email list" sheet is 4 different values 70%, 80%, 90% and 100%. when the "MAX" reaching these numbers I need to trier alerts. so for example when it reaches 70% email will be send to one person, when it reaches 80 it will send it to different person up until 100%.

Your AlertS macro already distinguishes between the different MAX tiers

This will trigger when the tier level changes, and not for a small change within the same tier. Is that what you meant?

Please Login or Register  to view this content.

[ball32]

Thank you very much for this this is exactly what I was looking for. Perhaps you can help me with the sending chart bit as well?