logo
search
Document Editing Problems

How to Create and Email Individual PDFs from Word Mail Merge

Maira MehtabMaira Mehtab Sep 22, 2026 868 views

Question details

The user needs to generate individual, separately named PDF files from a Word mail merge and email each file to a specific contact.

Product
Microsoft Word
Device & OS
not provided
Scenario
Sending personalized PDF attachments to multiple recipients via email using a mail merge process.
Observed behavior
Standard Microsoft Word mail merge does not natively support exporting to individual, separately named PDFs and emailing them as attachments simultaneously without the use of third-party add-ins.
Before you start

Ensure your Excel data source is properly formatted with headers in the first row containing only alphanumeric characters and no leading numbers. You will also need to have Classic Outlook installed and set as your default email client, as the new Outlook application does not support these COM add-ins.

Solution 1Recommended

Use the Merge Tools Add-in (Recommended)

Use a trusted third-party add-in to easily merge documents into individual PDFs, name them dynamically, and email them as attachments.

The Merge Tools Add-in extends Microsoft Word's native capabilities, allowing you to bypass default limitations and directly generate individual PDF files tailored for each recipient.

1
Download the Add-in

Download and install the Merge Tools Add-in from mergetoolsaddin.com.

2
Configure the Main Document

Open your Microsoft Word mail merge main document and ensure the merge type is specifically set to 'Letters'.

3
Prepare the Data Source

Format your Excel data source: ensure field names in the first row are under 40 characters, contain only alphanumeric characters, and do not begin with a number.

4
Execute Merge with Attachments

Navigate to the newly added Merge Tools tab on the Word ribbon and select the 'Merge with Attachments' feature.

5
Set PDF Output and Email

Configure the output settings to PDF, define the naming convention using your data fields, and run the merge to dispatch the emails via Classic Outlook.

Outlook Compatibility: This add-in requires the classic version of Microsoft Outlook. It will not function with the 'New Outlook' application.
Free Microsoft Office alternative

Try WPS Office for Powerful Document and PDF Processing

If managing complex mail merges and external add-ins in Microsoft Word is frustrating, consider switching to WPS Office. It provides a lightweight, fully compatible, and user-friendly alternative with built-in PDF tools for all your document needs.

  1. 1. Download the Installer: Visit the WPS Office website and click the download button for your operating system.
  2. 2. Install WPS Office: Run the lightweight installer and follow the on-screen instructions to complete the setup in minutes.
  3. 3. Open Your Files: Open your existing Word (.docx) and Excel (.xlsx) files directly in WPS Office to resume your work instantly.
High compatibility with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in PDF toolkit for easy document-to-PDF conversions and handling without complex add-ins.Free, lightweight suite that installs quickly on Windows, Mac, and Linux.Familiar ribbon interface ensures a seamless migration from Microsoft Office.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I email individual PDFs directly from standard Word mail merge?

Natively, Microsoft Word's mail merge to email feature sends the content in the body of the email or as an HTML attachment. It lacks a built-in function to split the merge into separate, dynamically named PDF attachments, making third-party add-ins necessary.

Does the Merge Tools add-in work with the New Outlook?

No, the Merge Tools add-in relies on COM integrations that are only supported by Classic Outlook. You must revert to or install Classic Outlook to use the merge to email feature.

How should I format my Excel data for the Merge Tools add-in?

Your Excel headers in the first row must contain only alphanumeric characters, be no longer than 40 characters in length, and cannot start with a number.

Can I name the individual PDF files based on recipient data?

Yes, by using add-ins like Merge Tools or Merge and Split, you can select a specific field from your Excel data source (such as the recipient's name or a unique ID) to automatically and dynamically name each generated PDF file.