Attachment Issues

How to Mail Merge Access Records to Individual PDF Emails

Partner Editor Sep 28, 2026 869 views

Question details

The user needs to merge approximately 80 Microsoft Access query records into separate PDF documents and automatically email each PDF to the corresponding customer.

How to Mail Merge Access Records to Individual PDF Emails

Product: Microsoft Word, Microsoft Access, Microsoft Outlook
Device & OS: not provided
Scenario: Automating the creation of individual PDF documents from an Access database and sending them as email attachments for tasks like membership application verification.
Observed behavior: Currently looking for an automated way to generate separate PDF files per record and attach them to individual emails, rather than generating one large merged document.

Before you start

Ensure you are using the classic version of Microsoft Outlook, as most mail merge add-ins do not support the 'New Outlook' interface. Verify your Access database queries are properly formatted and contain valid recipient email addresses.

Solution 1Recommended

Use a Mail Merge Add-in to Create and Email PDFs

Utilize a third-party add-in to split a standard Word mail merge into individual PDFs and automatically send them via Outlook.

This method requires setting up a standard Letters-type mail merge in Microsoft Word linked to your Access table or query. You will need a specialized add-in (such as Merge Tools) and classic Microsoft Outlook to handle the email automation.

Set up a Letters-type Mail Merge

Open Microsoft Word, go to the 'Mailings' tab, click 'Start Mail Merge', and select 'Letters'.

Connect Access Data

Click 'Select Recipients', choose 'Use an Existing List', and locate your Access database and the specific query containing your records.

Insert Merge Fields

Draft your document and insert the necessary merge fields from the 'Mailings' tab to populate the member details.

Run the Add-in

Use your installed mail merge splitting add-in. Configure the settings to output as 'PDF' and select the email field from your database as the destination address.

Send Emails via Outlook

Execute the merge through the add-in. It will automatically generate individual PDFs and pass them to classic Outlook to send as email attachments.

Use a Mail Merge Add-in to Create and Email PDFs

Outlook Version Support: This automated add-in method requires classic Outlook; it does not currently support the New Outlook application.

Solution 2

Use Microsoft Access Reports to Export and Email PDFs

Bypass Word entirely by using built-in Access report filtering and VBA to generate and email PDF files.

Free Microsoft Office alternative

Try WPS Office for Lightweight and Powerful Document Management

While complex database automation requires Microsoft Access, for your everyday document, spreadsheet, and mail merge needs, WPS Office offers a completely free, lightweight, and highly compatible alternative. Enjoy seamless format compatibility and a familiar interface without the hefty subscription fees.

100% compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Built-in Mail Merge features and PDF conversion tools for easy document sharing and bulk processing.Lightweight software that runs smoothly on older devices and consumes minimal system resources.Familiar user interface makes switching easy and requires almost no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I use the New Outlook to mail merge individual PDFs?

No, most classic mail merge add-ins rely on COM integration that is only supported in classic Microsoft Outlook. You will need to switch back to the classic version to automate PDF attachments.

How do I avoid virus warnings when downloading mail merge add-ins?

Third-party macro-enabled templates are often flagged by security software as false positives. Ensure you are downloading tools from a reputable source, or bypass add-ins altogether by using VBA to export Access Reports directly to PDF.

Can I merge to individual PDFs natively in Word without an add-in?

Natively, Microsoft Word's mail merge to email feature sends the document content in the body of the email or as a single standard attachment. It does not natively split and attach individual PDFs without the use of a custom VBA macro or a third-party add-in.

Outlook & Email Problems