Others

How to Send Notifications When Microsoft Access Records Are Changed

Anum MushtaqAnum Mushtaq Nov 3, 2026 869 views

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.

How to Send Notifications on Microsoft Access Record Changes
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Table Events

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.

2
Select the Trigger Event

Click on 'After Insert', 'After Update', or 'After Delete' to open the Macro Builder for that specific action.

3
Add the Email 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.

4
Save and Test

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.

Use Access Data Macros for Email Notifications
Workflow Consideration: If your database undergoes frequent changes, sending an email for every single field update might cause notification fatigue. In high-volume databases, consider logging changes instead.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website to download the free installation package.
  2. 2. Install the Suite: Run the installer and complete the quick setup process on your Windows, Mac, or Linux device.
  3. 3. Start Managing Data: Open WPS Spreadsheet to start managing your data logs with full compatibility with Excel formats.
Seamlessly compatible with Microsoft Excel (.xlsx) formats for easy data logging, reporting, and sharing.Free and lightweight suite including Writer, Spreadsheet, Presentation, and PDF tools.Familiar user interface ensuring zero learning curve for users migrating from Microsoft Office.Built-in collaboration and version history features for tracking changes efficiently.
microsoft office alternative - wps office

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.