Sending auto email notification

[Disneyfan via AccessMonster.com]

I am creating an Access database that I would like to set up automated email
notification to select users to inform them that a due date for a certain
business filing is coming due (2 weeks before due date). I would also like to
set recurring dates in Access for certain filings. For example, we need to
create annual business filings, quarterly filings, etc. I saw the thread to
set code for specific project due dates, but not recurring dates. Thanks in
advance.

 

[Steve Schapel]

Disneyfan,

I can't give any explicit help here, without knowing more details of
your requirements. But here's the basic concept...
1. Make a table that lays out the Filing, DueDate, RecurringCycle, and
EmailRecipients.
2. Write some code that checks this table every time the database
application is opened, and if any of the DueDates is within 2 weeks,
will do this...
- emails the notification to the EmailRecipients
- updates the DueDate field to the subsequent filing period