send mail on value
I find myself in need of a way to send an email via excel when a cell gets to
a certain value. I have the recipients email in A1. In B1 I have the number
of days remaining till his certification expires. B1 is dynamic and changes
every day so thats not the issue. I need a way to email the address in A1
when B1 drops below 30.
|