Setting Up Reminders (Office 2003)

Topic

New Reply

Hi everyone,
Am working with excel 2003 and have this file which lists all responses to be received with dates.
Is it possible to have an automated popup or,to highlight a corresponsing cell with yes or no or better still a macro to send an
email to a defined user to ensure timely follow-ups… say 3 days prior to expiry dates. Currently all I do is highlight same in a different colour but that is really not good enough..
So look foward to some smarter options.

Thanks, francis

Reply | Quote

Replies

How do you want to initiate this? Should the user click on a command button, or should it be done automatically each time the workbook is opened, or …?
If you were to send an e-mail, do you want to send it again the next time, or should each response be marked in some way when an e-mail has been sent?

Reply | Quote

Hi Hans,
Thank you for your prompt response. A command button to get all the “no” and with a marked stated that a final reminder have been send to the user on the date 3 days prior to the deadline will be idea.

cheer, francis

Reply | Quote

You can use the attached workbook as starting point; adapt for your specific needs.
The workbook contains a macro, so make sure that macro security is not set to High and that you enable macros.
If you need to send a more elaborate e-mail, you’d need to automate Outlook. This is more work.

Reply | Quote