Other PDF Issues

How to Name Mail Merge PDFs Using a Merge Field

Natalie TaylorNatalie Taylor Nov 10, 2026 869 views

Question details

The user wants to know how to automatically name individual PDF files generated from a mail merge using a specific data merge field.

How to Name Mail Merge PDFs Using a Merge Field
Product
Adobe Acrobat / Microsoft Word
Device & OS
not provided
Scenario
Performing a mail merge to output multiple PDF files and attempting to assign dynamic filenames based on recipient data fields.
Observed behavior
Native Acrobat and Microsoft Word mail merge workflows lack a built-in option to split and name generated PDFs using merge fields out-of-the-box, often requiring custom macros or add-ins.
Before you start

Ensure your data source (such as an Excel spreadsheet) contains a dedicated column with the exact text you want to use for the final PDF filenames without any invalid file characters like slashes or asterisks.

Solution 1Recommended

Use a Mail Merge Add-in or Macro in Microsoft Word

Since native Acrobat lacks dynamic naming for merged PDFs, utilizing an automated mail merge add-in or a VBA macro within Microsoft Word is the most reliable method.

Microsoft Word's native Mail Merge feature can merge data directly into a single PDF or send emails, but it cannot natively split the output into multiple PDFs named by a data field. A third-party add-in or custom VBA macro is required to unlock this capability.

1
Prepare the Data Source

Open your Excel spreadsheet and verify that a specific column (e.g., 'FileName') holds the desired output names for each document.

2
Set up the Word Document

Open your Word template, navigate to the 'Mailings' tab on the ribbon, and click 'Select Recipients' to connect your Excel list.

3
Configure the Add-in or Macro

Launch your installed PDF merge add-in or open your macro script. In the settings menu for the tool, locate the 'Output Filename' or 'Save As' option.

4
Map the Filename Field

Select the 'FileName' merge field from the dropdown menu to instruct the tool to use this column for naming the generated files.

5
Execute the Merge

Click the 'Merge to PDF' or equivalent run button provided by the add-in to generate and save individual PDFs with dynamic names to your target folder.

Use a Mail Merge Add-in or Macro in Microsoft Word
Third-Party Tools Requirement: Popular tools for this process include Adobe Acrobat's extended PDFMaker add-in (if supported in your version) or dedicated utilities like AutoMailMerge and Merge Tools.
Free Microsoft Office alternative

Handle Your Documents and Mail Merges with WPS Office

If you are frustrated by the limitations and high costs of complex Adobe Acrobat or Microsoft Word workflows, try WPS Office. It provides a lightweight, highly compatible suite for word processing, spreadsheets, and PDF management without the heavy subscription fees.

  1. 1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
  2. 2. Open WPS Writer: Launch WPS Writer and navigate to the 'References' or 'Mailings' tab to access the Mail Merge feature.
  3. 3. Connect Data and Merge: Click 'Open Data Source' to link your spreadsheet, insert your merge fields, and quickly generate your customized documents.
Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats, ensuring your data sources work seamlessly.Built-in robust PDF editor to view, split, merge, and edit PDF documents natively.User-friendly Mail Merge interface that easily connects to your spreadsheet data for quick document generation.Free and lightweight alternative to heavy Microsoft Office installations.
QA img-9

Frequently Asked Questions

Can Microsoft Word natively save mail merge documents as separate PDFs with dynamic names?

No, Microsoft Word's native Mail Merge feature can output to a single combined PDF or send documents directly as emails, but it does not have a built-in function to split and save individual PDFs named after a specific merge field. A VBA macro or third-party add-in is typically required.

What is the best format for the mail merge data source to ensure error-free naming?

Excel spreadsheets (.xlsx) or CSV files are the most reliable formats. Ensure the first row contains clear column headers (like 'FileName') without any merged cells, and ensure the data within the filename column does not contain illegal characters like slashes (/, \), colons (:), or asterisks (*).

Are there free alternatives to Adobe Acrobat for managing and splitting PDFs?

Yes, comprehensive office suites like WPS Office include built-in PDF toolkits that allow you to view, edit, split, and merge PDF files natively. It serves as an excellent all-in-one alternative for document and PDF management.