dates in Excel act as a reminder

B

bigvarn

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?
 
D

DC

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.
 
D

Dave Peterson

If you're using Outlook, why not just add an activity to your outlook calendar?
 
Top