Others

How to Send Automated Microsoft Access Emails for New Records

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 868 views

Question details

The user needs to automatically email each newly imported product-failure record from a Microsoft Access database that receives data from Google Forms through a linked Excel table.

How to Send Automated Microsoft Access Emails for New Records
Product
Microsoft Access
Device & OS
not provided
Scenario
The quality department tracks product-failure records in Access and wants only newly imported records sent by email, likely using SendObject or an Access report.
Observed behavior
The linked Excel table has no primary key; a query and report display only the newest record, and automated email, MAPI configuration, and multiple-record handling are not yet implemented.
Before you start

Confirm that the linked Excel table has a unique identifier or reliable timestamp for each imported row, and verify that the computer has a MAPI-compatible email client configured so Access can use SendObject.

Solution 1Recommended

Add a Unique Identifier and Mark Emailed Records as Processed

Use this method when you can modify the source Excel workbook or import process; it is the most reliable way to make automation safe.

A unique record ID or timestamp paired with a Yes/No emailed flag prevents a top-1 query from missing records when multiple product failures arrive between automated runs.

1
Add a unique column in Excel

Open the workbook populated by Google Forms, add a RecordID or confirm that the timestamp column is unique for every row, and save the Excel file.

2
Refresh the linked table in Access

In Microsoft Access, click External Data > New Data Source > From File > Excel and link or refresh the linked table so the new unique field and any emailed-status column appear.

3
Add an emailed status field

Open the linked table or a local staging table in Design View, add an EmailSent field as Yes/No, and save the table.

4
Create an update query

On the Create tab, click Query Design, add the table, set the query type to Update, set EmailSent to Yes, and add criteria for the unique record ID you just emailed.

5
Run the update query after sending

Call this update query from a macro or VBA immediately after SendObject succeeds so processed records are excluded from future email runs.

Add a Unique Identifier and Mark Emailed Records as Processed
Why avoid using only the top record?: A query sorted by timestamp and limited to one row will skip records when more than one new product-failure row arrives between email sends.
Free Microsoft Office alternative

Use WPS Office as a Free Microsoft Office Alternative for Excel-Based Record Tracking

Microsoft Access SendObject automation is a Microsoft Office feature, and WPS Office does not run Access macros or VBA. For the spreadsheet side of this workflow, WPS Office offers a free, lightweight, familiar alternative that opens .xlsx files, preserves Excel formatting compatibility, and helps you review and clean product-failure records before they enter a database.

  1. 1. Download WPS Office: Click Download WPS Office Free, install the version for Windows, macOS, Linux, or mobile, and sign in or continue as a free user.
  2. 2. Open the Excel source workbook: In WPS Spreadsheets, click Menu > Open and select the Google Forms/Excel workbook that feeds the Microsoft Access import.
  3. 3. Review and prepare the data: Use sorting, filtering, and duplicate tools in WPS Spreadsheets to verify unique timestamps or add a RecordID column, then save the file as .xlsx.
Free Microsoft Office alternative with a familiar ribbon-style interfaceOpens and saves .xlsx Excel files with strong formatting compatibilityLightweight spreadsheet tools for reviewing and cleaning product-failure recordsSeamless migration for teams that mainly work in Excel rather than Access
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access query return only one record when several new failures arrived?

Because the query is likely sorted by timestamp and limited to one row. Replace it with an unmatched query or a unique ID plus a processed flag so every new record is selected before the email is generated.

Can I use SendObject to send an Access report automatically when a record is added?

Access does not have a simple row-level trigger on a linked Excel table. You need a scheduled macro, form event, or VBA routine that runs a new-record query, sends the report with EMailDatabaseObject or SendObject, and then marks or appends the records as processed.

Do I need a primary key in the linked Excel table?

Yes, for reliable automation you need a unique identifier for each record. A timestamp can work only if it is guaranteed unique; otherwise add a RecordID or compare against a local tracking table.

How do I fix MAPI errors when sending email from Access?

Install and configure a MAPI-compatible email client such as Outlook, create a mail profile, test a manual SendObject first, and avoid sending unattended until the profile can deliver mail without prompts.

Can WPS Office run Microsoft Access macros or SendObject?

No, WPS Office does not include Microsoft Access or Access VBA/SendObject. However, WPS Spreadsheets can open and edit the .xlsx source workbook used for the import, so you can prepare data for your existing Access workflow.