How to Customize PDF File Names During Acrobat Mail Merge
Question details
The user wants to generate personalized PDF file names based on client data from Word or Excel during a mail merge, rather than receiving generic sequential names.
- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Running a mail merge to create multiple personalized PDFs and attempting to name each output file dynamically using data source fields.
- Observed behavior
- The generated PDF files are saved with generic, incremental names such as 'PDF Mailer 1' and 'PDF Mailer 2' instead of the desired client names.
Ensure your source data file (such as an Excel spreadsheet) contains a dedicated column with clean, invalid-character-free text to be used for the desired file names.
Use an Acrobat JavaScript Mail Merge Script
Since the default Acrobat mail merge behavior generates sequential file names, using a custom Acrobat JavaScript or a third-party mail-merge script allows you to map file names directly to PDF field values.
Native Adobe Acrobat does not always support dynamic file naming based on merge fields directly out of the box. By utilizing a specialized script, you can extract values from specific PDF fields (like a client-name field) and command Acrobat to use those values as the file name during the saving process.
Locate a reliable Acrobat JavaScript tool or third-party plugin designed for mail merge, such as the widely recommended Try67 mail merge script, which supports dynamic naming and automated emailing.
Load the acquired JavaScript file into your Adobe Acrobat application according to the script provider's installation instructions.
Launch the custom mail merge tool from within Acrobat. In the configuration settings, specify the naming pattern by selecting the merge field (e.g., 'Client Name') that you want to use for the file names.
Before generating hundreds of documents, process a small test batch to verify that the PDFs are successfully inheriting the names from your selected data fields.
Use Microsoft Word Mail Merge with the Adobe PDF Maker Add-in
If scripting in Acrobat is too complex, you can manage the merge directly in Microsoft Word and use the Adobe PDF Maker add-in to generate individually named PDFs.
Streamline Your Document Workflows with WPS Office
If you frequently manage complex document merges, data sources, and PDF conversions, consider switching to WPS Office. It provides a highly compatible, lightweight, and free alternative to Microsoft Office, complete with an integrated PDF toolkit to simplify your daily tasks.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Your Data Sources: Open your existing Word document templates and Excel data files seamlessly without formatting loss.
- 3. Utilize Built-in PDF Tools: Take advantage of WPS Office's integrated PDF conversion tools right from your Writer or Spreadsheet application.
Frequently Asked Questions
Why does Acrobat save my mail merge files as 'PDF Mailer 1'?
By default, Acrobat's basic mail merge functionality generates sequential file names (like PDF Mailer 1, PDF Mailer 2) because it does not automatically map specific data fields from your source file to the final output file name without the use of advanced scripting.
Can I use Excel data fields to name PDFs in Acrobat?
Yes, but native Acrobat doesn't handle this natively. You will need to employ Acrobat JavaScript or install a third-party mail merge script that allows you to map an Excel column (such as 'Client Name') directly to the PDF output file name.
Does Microsoft Word natively export merged documents to individual named PDFs?
Native Word mail merge typically exports the merge as a single large document or sends it directly to a printer or email. To export to individual PDFs that are named dynamically, you must use the Adobe PDF Maker add-in within Word or utilize third-party VBA macros.
