How to Send Notifications When Microsoft Access Records Are Changed
Question details
The user needs a method to automatically notify designated personnel when a record in a shared Microsoft Access database is inserted, updated, or deleted.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Managing a workplace database where multiple users interact with records, requiring automated workflow notifications to avoid manual checks.
- Observed behavior
- Users currently have to manually inspect the database to find new or modified entries, which is inefficient for the workflow.
Ensure you have exclusive access to the Microsoft Access database before configuring Data Macros, and verify that your desktop email client (like Outlook) is properly configured to send automated messages.
Use Access Data Macros for Email Notifications
Create Data Macros triggered by After Insert, After Update, or After Delete events to automatically send an email via Outlook.
Data macros run directly within the Access database engine. They are ideal for triggering automated processes like email notifications whenever data is altered, regardless of whether the change was made in a form or directly in the table.
Open your Microsoft Access database and navigate to the specific table you want to monitor. Click on the 'Table' tab in the ribbon, then locate the 'Table Events' group.
Click on 'After Insert', 'After Update', or 'After Delete' to open the Macro Builder for that specific action.
In the Macro Builder, use the 'SendObject' action (or your custom VBA email function). Specify the recipient's email address, subject line, and the message text. You can include references to the changed fields.
Save and close the macro. Test the workflow by manually adding or modifying a record in the table to ensure the notification email is dispatched.

Create a Change Log Table and Send Periodic Summaries
Log modifications to a separate tracking table and review them periodically to reduce email overload.
Try WPS Office for Your Document and Data Needs
While Microsoft Access handles complex relational databases, you can manage extensive data tracking, logs, and collaborative lists seamlessly using WPS Spreadsheet. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office suites, helping you streamline your workplace data without heavy licensing costs.
- 1. Download WPS Office: Visit the official WPS Office website to download the free installation package.
- 2. Install the Suite: Run the installer and complete the quick setup process on your Windows, Mac, or Linux device.
- 3. Start Managing Data: Open WPS Spreadsheet to start managing your data logs with full compatibility with Excel formats.

Frequently Asked Questions
Can I send notifications to multiple email addresses using Access Data Macros?
Yes, you can specify multiple email addresses separated by semicolons in the 'To' or 'Cc' arguments of the SendObject macro action.
Will Data Macros run if the Access database is updated via an external query?
Yes, Data Macros operate at the Access engine level (ACE). They will trigger even if records are updated from external sources, forms, or direct table edits, as long as the engine processes the change.
How do I track exactly which fields were changed during an update?
Within an 'After Update' Data Macro, you can use the 'Old' variable syntax (e.g., [Old].[FieldName]) to compare the previous value with the new value. You can then log or send alerts for only the specific fields that differ.
How can I prevent Outlook security warnings when Access sends an email?
This is a built-in Outlook security feature. You can bypass it by keeping your antivirus software updated so Windows recognizes it as valid, configuring Outlook's Programmatic Access Security settings, or using third-party utility tools designed to handle automated email prompts.




