How to Send Automated Microsoft Access Emails for New Records
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.

- 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.
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.
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.
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.
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.
Open the linked table or a local staging table in Design View, add an EmailSent field as Yes/No, and save the table.
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.
Call this update query from a macro or VBA immediately after SendObject succeeds so processed records are excluded from future email runs.

Compare Linked Excel Rows Against a Local Tracking Table
Use this method when you cannot modify the Excel source workbook but still need to identify every new record before emailing.
Automate SendObject to Send the Report and Update the Report Before Sending
Use this method after you have a query or tracking method that reliably returns only new records; it configures the actual Access email automation.
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. 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. 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. 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.

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.




