How to Automate Email Reminders Before Tasks in Access VBA
Question details
The user needs a method to automate sending email reminders to assigned team members before project tasks begin without violating database normalization rules.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Managing project tasks and team member assignments while ensuring participants receive timely email notifications ahead of their scheduled duties.
- Observed behavior
- The database contains repeating groups for team members, and the user needs a structured way to trigger emails automatically since Access can only send emails while the database is open.
Ensure you have backup copies of your database before modifying table structures, and verify that your Windows user account has administrator permissions to create and run scheduled tasks.
Normalize Database and Automate Emails via VBA and Task Scheduler
Restructure your tables to meet normalization rules, then use a VBA script combined with Windows Task Scheduler to send emails automatically without manual intervention.
To properly automate tasks in Microsoft Access, the database must first be normalized to prevent redundant data. Since Access cannot execute code while closed, a separate front-end file and Windows Task Scheduler are required to run the automation daily.
Eliminate repeating groups like 'Team Member 1' and 'Team Member 2' by creating a separate related table. Ensure there is only one record per team member per project or task, and store email addresses centrally to avoid redundancy.
Set up a dedicated Access front-end file specifically for running the automation, ensuring it connects securely to your back-end data tables where the task schedules are stored.
In your front-end database, create a VBA module using the DoCmd.SendObject command. Write a script that loops through your task table and generates emails for any tasks scheduled to start the next day.
Open Windows Task Scheduler and create a new basic task. Set the trigger to run daily at a specific time, and set the action to start a program, pointing it to open your automated front-end Access database.

Looking for a Lightweight, Highly Compatible Office Alternative?
While Microsoft Access handles complex database management, WPS Office provides a free, lightweight, and incredibly capable suite for all your daily spreadsheet, document, and presentation needs with a familiar user interface.
- 1. Download and Install WPS Office: Get the free installation package from the official WPS website and install it on your device in minutes.
- 2. Open Existing Office Files: WPS Office automatically recognizes and opens your existing Excel, Word, and PowerPoint files with perfect formatting compatibility.
- 3. Enjoy Familiar Tools: Start working immediately using a familiar ribbon interface and standard shortcut keys without any steep learning curve.

Frequently Asked Questions
Can Microsoft Access send automated emails while closed?
No, Access cannot execute VBA scripts or send emails while it is closed. You must use a tool like Windows Task Scheduler to open the database automatically so the VBA script can run.
Why shouldn't I use fields like 'Team Member 1' and 'Team Member 2'?
Using numbered fields for similar data creates repeating groups, which violates database normalization rules. It makes querying difficult and limits scalability. Instead, create a separate related table with one record per team member per project.
What VBA command is used to send emails in Access?
The DoCmd.SendObject method is typically used in Access VBA to send emails. It allows you to output database objects or send plain text emails via your system's default MAPI email client, such as Microsoft Outlook.




