Can Excel automatically send an e-mail notification upon reaching a set cell value?

[cbeckhuson]

Hello Everyone,

I am learning to use excel and loving the usefulness of the program. I am an electrical superintendent up in northern Canada and what I am working on is an estimating spreadsheet. I have worked hard to make it so that all I have to do is count the various small tasks involved in a given building and excel will generate an estimate on time. It has already streamlined my business and greatly improved my efficiency. I just have one more thing that I would like to add to my workbook to make it perfect. What we have come to realize is that our QA/QC representative can also use this spreadsheet to his benefit by looking at the percentage completion cell value so he will know when its time for him to go inspect the workers installation. If the cell value is greater than 90% then he can begin his job, so I was wondering if there was any way to have Excel automatically email my QA/QC rep the moment that the progress reaches 90% or beyond. This would be awfully slick and I am too much of a nube to figure it out.

Any help would be GREATLY appreciated.

Thanks!

[Bishonen]

Yup, it would be possible.

This code would catch the event of a cell changing to > 90%

Please Login or Register  to view this content.

This one would send an email to your colleague:

Please Login or Register  to view this content.

You have to add a reference to the Microsoft Outlook Library.

[cbeckhuson]

Thanks Bishonen!

Is there any way that you could explain to me how to enter these codes into excel? Sorry for the imposition, I am just a little out of my element with all this stuff. I am very grateful for any assistance that you might have. Thanks again!