View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan Ryan is offline
external usenet poster
 
Posts: 124
Default 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.