Setup Multiple Timers

I haven't started writing this macro yet, as I'm hoping for some guidance on how to start.

I have an Excel report listing various reports that need to be sent on a timely basis (weekly, monthly, annually, a specific date, etc.). I'd like to have timers set to mail out reminders to the responsible parties a few days in advance. I know how to do all of the email stuff, just not how to do the timers. Plus, the spreadsheet containing the report isn't opened every day, so I don't know how to automatically open the spreadsheet to trigger the timer to remind the person.

Can anyone help me get started?

You can have code in the Workbook Open event that decides what needs to be done when the workbook opens on some given date.

Then schedule the workbook to open at appropriate times using Windows Task Scheduler (http://support.microsoft.com/kb/308569).

Create your own digital certificate and sign the project so that macros will be enabled when the workbook opens.

Task Scheduler:
Start > Control Panel > Scheduled Tasks > Add Scheduled Task, browse to the workbook, set the recurrence

Digital certificates:
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx
http://support.microsoft.com/kb/206637
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx