Microsoft Access - Automatic Email (access) - monthly, quarterly, etc

I have a list of tasks in Microsoft Access that vary in terms of when they are due, and they are all done on a repetitive basis.  Some of them are done daily, monthly, quarterly, and yearly.  I want Access to send out an automatic email to the person(s) the task is assigned to based on when the task is due.  For the monthly tasks, I want access to send this email out 2 days prior to the task due day.  For the quarterly tasks, I want access to send out the reminder email 2 weeks prior to the due date, etc, etc.  Is there a way I can set the task to be repeated daily, monthly, quarterly, etc, and have access send out the email automatically?

Thanks
Adam

I am not sure if we can have access process scheduled but you can achieve the email send scheduling by creating a simple VB.NET console app that will check the access DB and then put the app in windows scheduler.

You can open Access through a Windows Scheduled Task. What you will need to ensure you have is a startup form that runs the script. For example, I have a report generator on a virtual machine that, every hour, opens, checks to see if any reports need to be processed, and if so, exports that report to PDF then attaches to an email addressed dynamically from the recordset.

Rather than have the code behind a startup form run the emails, this is one of the few cases where it is appropriate to use a macro.  You can use Windows Scheduler to schedule Access to run each day at a particular time.  The bat file that runs Access can specify the name of a macro to run when Access is opened.  This bypasses the startup form and allows you to use the same database for both interactive and batch processes.

is there a sample that I can try this automatic email?