Others

How to Automatically Email Reminders for Overdue Claims in Access

Steven ParkerSteven Parker Nov 2, 2026 869 views

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.

How to Automatically Email Reminders for Overdue Claims in Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the Pending Claims Query

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;

2
Build the AutoExec Macro

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'.

3
Configure Windows Task Scheduler

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'.

4
Link the Database to the Task

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.

Automate Email Reminders via AutoExec Macro and Task Scheduler
Testing the Automation: You can test the process by right-clicking your newly created task in Task Scheduler and clicking 'Run'. Access should briefly open, send the email via your default client, and then close.
Free Microsoft Office alternative

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.

Highly compatible with Microsoft Excel (.xlsx, .xls) formats for easy data migration and tracking.Track due dates and pending claims visually using built-in conditional formatting and formulas.Lightweight installation with an intuitive, familiar user interface that requires no steep learning curve.Free access to a complete suite of productivity tools including Spreadsheets, Writer, Presentation, and PDF editor.
QA img-9

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.