Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic notify
Hi - Is there an option within excel that will once you
reach a certain anniversary date (date field reaches one year from entry) it will display a popup or send an email. I'd like the option to give me a reminder one year to schedule another appointment |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic notify
The easiest would be to have conditional formatting color the cell. That
would require you to look at the sheet periodically. If you want to send mail, you can see the following sites for sample code: Ron de Bruin http://www.rondebruin.nl/sendmail.htm http://msdn.microsoft.com/library/en...odc_xlmail.asp Dick Kuselika www.dicks-clicks.com Tim Zych www.rubbershoe.com/olmail.htm Since your posting in programming, I assume you won't comeback and say "VBA, what's that?" -- Regards, Tom Ogilvy "ZRM" wrote in message ... Hi - Is there an option within excel that will once you reach a certain anniversary date (date field reaches one year from entry) it will display a popup or send an email. I'd like the option to give me a reminder one year to schedule another appointment |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Notify of Replies | Excel Discussion (Misc queries) | |||
notify of entered criteria | Excel Worksheet Functions | |||
Notify Message? | Excel Discussion (Misc queries) | |||
Notify | Excel Discussion (Misc queries) | |||
Can excell notify me of due dates? | New Users to Excel |