How to Automatically Email Reminders for Overdue Claims in Access
Question details
The user needs a way to automatically trigger email reminders for unprocessed or overdue claims in Microsoft Access without manually opening the database application every day.

- Product
- Microsoft Access
- Device & OS
- Windows
- Scenario
- Setting up a daily scheduled task to identify pending claims approaching or exceeding their due dates and dispatching email notifications to the relevant parties automatically.
- Observed behavior
- Microsoft Access requires the database to be actively open to run the SendObject macro. Automation is halted because the required macro cannot execute while the database is closed.
Ensure that your default Windows email client (such as Microsoft Outlook) is properly configured and running in the background, as the Access SendObject macro relies on the default MAPI client to dispatch emails.
Automate Email Reminders via AutoExec Macro and Task Scheduler
By combining an Access AutoExec macro with Windows Task Scheduler, you can force the database to open on a schedule, dispatch the pending claim emails, and close automatically.
Microsoft Access cannot run background queries or send emails when it is closed. To bypass this, you can create a specialized front-end database that runs an 'AutoExec' macro immediately upon opening. Windows Task Scheduler can then be used to handle the daily launch.
Open your Access database, go to the 'Create' tab, and click 'Query Design'. Switch to 'SQL View' and enter a query to filter unpaid claims approaching their due date. For example: SELECT [Date of Claim], [Name of Customer], [Claim number], [Due Date], [Current Status] FROM [Table] WHERE [Current Status] <> 'Paid' AND [Due Date] <= Date()+5;
Navigate to the 'Create' tab and select 'Macro'. Add a new action called 'EMailDatabaseObject' (or 'SendObject'). Set the Object Type to your newly created Query (or a Report based on it) and configure the To, Subject, and Message fields. Add a second action called 'QuitAccess' so the database shuts down after emailing. Save this macro exactly as 'AutoExec'.
Press the Windows key, type 'Task Scheduler', and open the application. Click 'Create Basic Task' in the right pane. Name it 'Daily Claim Reminders' and set the Trigger to 'Daily'.
For the task Action, choose 'Start a program'. In the 'Program/script' box, browse and select your Microsoft Access executable (msaccess.exe). In the 'Add arguments' box, paste the exact file path to your Access database enclosed in quotes. Save and enable the task.

Manage Data and Track Claims Effortlessly with WPS Office
While Microsoft Access is powerful for relational database automation, it can be overly complex for simple claim tracking. WPS Office Spreadsheets offers an intuitive, lightweight alternative for organizing claims, filtering due dates, and maintaining your records—completely free.

Frequently Asked Questions
Why doesn't the SendObject macro run automatically when Access is closed?
Microsoft Access is a desktop application, not a background service. It must be actively running and the database opened to execute any macros, queries, or VBA code, including the SendObject command.
Can I test the AutoExec macro without waiting for the scheduled time?
Yes. Since it is named 'AutoExec', it runs every time the database opens. Simply close and manually re-open the database to verify that the email generates and the application quits as expected.
How do I prevent the AutoExec macro from running when I want to edit the database?
To bypass the AutoExec macro and open the database for editing, hold down the 'Shift' key on your keyboard while double-clicking the database file. Keep holding Shift until the database fully opens.
Does this automation require Microsoft Outlook?
While Outlook is the most common client, the SendObject command relies on the default MAPI (Messaging Application Programming Interface) email client configured in your Windows settings. Any fully MAPI-compliant email application will work.




