Send an email using VBA when a cell value changes

[Closed]

Report

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: ***@***

Send an email using VBA when a cell value changes
Vba first empty cell in row - How-To - Excel
Facebook not sending confirmation email 2020 ✓ - Forum - Facebook
Facebook code not sending to email ✓ - Forum - Facebook
Outlook keeps sending same email ✓ - Forum - Outlook
Excel vba msgbox when cell meets criteria ✓ - Forum - Excel

Send an email using VBA when a cell value changes

Your reply

Subscribe To Our Newsletter!