dates in Excel act as a reminder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a date entered in Excel to somehow remind me to do something on a
specific date. i.e. I would like my Excel workbook to notify me of an
appointment via Outlook. I have product end dates which I would like to be
notified of so I can call clients to remind them (and sell more things).

Using Excel 2000.

Anybody any ideas?
 
bigvarn said:
I want a date entered in Excel to somehow remind me to do something on a
specific date. i.e. I would like my Excel workbook to notify me of an
appointment via Outlook. I have product end dates which I would like to be
notified of so I can call clients to remind them (and sell more things).
Click to expand...

You could create a macro and use Msgbox("Reminder: xxxxx") to pop up the
reminder. You would have to have the macro check if any of the dates in that
column are today or earlier, then popup the details of it.
 
Back
Top