Send an email using VBA when a cell value changes

erikheath - Jan 10, 2017 at 04:04 PM
Can someone help? I have been struggling with this for days. VBA is something new to me and I think it hates me

I have a spreadsheet that updates based on a estimated completion dates. When the date passes the estimated completion date Column J changes to say "Overdue" and I would like to receive an email with the lab number when this happens.

Column A: Lab reference #
Column J: Lab Status
Email: ***@***