dates in Excel act as a reminder

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

 

[DC]

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

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.

 

[Dave Peterson]

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