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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
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" <[email protected]>
wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks