View Single Post
  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default Can excel send reminder emails on dates entered in a wookbook?

You can use the OnTime method to schedule a macro to be run. That
macro would then send the email. Excel must be kept up and
running the entire time. See www.cpearson.com/excel/ontime.htm
for more info about OnTime.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Doubting_her_boss"
wrote in message
...
My boss thinks that excel can generate an email on a date
entered into a
workbook. For example I can insert a "trigger date" column and
excel will
send her an email notice on the date I enetered.
Any truth to this? We use lotus notes.