Send an email using VBA when a cell value changes

Closed

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
Create a yahoo email account for free - Guide
Run macro when cell value changes - Guide
How to recover facebook password without email and phone number - Guide
If cell contains specific text then return value in another cell vba ✓ - Excel Forum
Free fire email id - Guide

Subscribe To Our Newsletter!