Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can excel send reminder emails on dates entered in a wookbook?
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. |
#2
|
|||
|
|||
Can excel send reminder emails on dates entered in a wookbook?
Hi
If excel is always open it is possible with Ontime http://www.cpearson.com/excel/ontime.htm You can check the date and run the mail code See for lotus notes code http://www.excelkb.com/?cNode=1X5M7A -- Regards Ron de Bruin http://www.rondebruin.nl "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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send Excel File As Read Only | Excel Discussion (Misc queries) | |||
I cannot save work I have entered in Micosoft Excel 2000- | Excel Discussion (Misc queries) | |||
have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
Excel Send To function problem | Excel Discussion (Misc queries) |