How to Name Mail Merge PDFs Using a Merge Field
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.

- 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.
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.
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.
Open your Excel spreadsheet and verify that a specific column (e.g., 'FileName') holds the desired output names for each document.
Open your Word template, navigate to the 'Mailings' tab on the ribbon, and click 'Select Recipients' to connect your Excel list.
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.
Select the 'FileName' merge field from the dropdown menu to instruct the tool to use this column for naming the generated files.
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.

Utilize Adobe Acrobat Plug-ins for Dynamic Naming
Use specialized Adobe Acrobat plug-ins designed specifically to handle complex PDF mail merges and dynamic file naming directly from the PDF interface.
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. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open WPS Writer: Launch WPS Writer and navigate to the 'References' or 'Mailings' tab to access the Mail Merge feature.
- 3. Connect Data and Merge: Click 'Open Data Source' to link your spreadsheet, insert your merge fields, and quickly generate your customized documents.

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.




