PDF Conversion Issues

Fix Adobe PDFMaker Not Recognizing Next Record Mail Merge Code in Word

Huda QurayshiHuda Qurayshi Nov 3, 2026 870 views

Question details

Adobe PDFMaker fails to recognize the <<Next Record>> Word mail merge code when attempting to merge an Excel data source directly to PDF.

Fix Adobe PDFMaker Next Record Mail Merge Code Error
Product
Microsoft Word
Device & OS
Windows 10
Scenario
Merging a Word document with an Excel data source into a PDF using the Adobe PDFMaker add-in in Office 365.
Observed behavior
PDFMaker throws an invalid mail merge code error for the <<Next Record>> field and fails to generate the merged PDF, although Word's native Finish & Merge function works perfectly.
Before you start

Ensure your Excel data source contains no blank columns and preview the merged results in Word first to confirm the data is mapped correctly before attempting the conversion.

Solution 1Recommended

Use Word's Native Finish & Merge Feature

Bypass the Adobe PDFMaker add-in entirely by generating the merged Word document first and natively exporting it to PDF.

Since the Adobe PDFMaker add-in sometimes struggles to parse dynamic Word fields like <<Next Record>> directly, breaking the process into two steps ensures flawless execution. You first generate a merged Word document, which can then be safely exported.

1
Click Finish & Merge

In your Word document, navigate to the Mailings tab. Ignore the 'Merge to Adobe PDF' button and click the 'Finish & Merge' button instead.

2
Edit Individual Documents

Select 'Edit Individual Documents' from the dropdown menu, choose 'All' records, and click OK to generate a new, fully merged Word document.

3
Save or Export as PDF

In the newly created merged document, go to File > Export > Create PDF/XPS Document, or go to File > Save As and choose PDF as the format. This circumvents the PDFMaker error entirely.

Use Word's Native Finish & Merge Feature
Preserved Formatting: Using Word's native PDF export retains the exact layout and data mapping as seen in your Print Preview.
WPS Office Direct Solution

Use WPS Writer for Seamless Mail Merge to PDF

WPS Office provides highly capable built-in mail merge and native PDF export functionalities, allowing you to seamlessly convert spreadsheets to PDF documents without relying on unstable third-party add-ins.

  1. 1. Open your Document in WPS: Launch WPS Writer and open your main mail merge template document.
  2. 2. Connect the Data Source: Navigate to the Mailings tab, click Open Data Source, and select your Excel spreadsheet.
  3. 3. Merge to New Document: Click Merge to New Document to natively process the <<Next Record>> rules into a single, comprehensive file.
  4. 4. Export to PDF: Go to Menu > Export to PDF to securely save the generated document as a PDF file without relying on external plugins.
Built-in Export to PDF feature natively handles merged document pages without add-in errorsFull compatibility with Microsoft Word (.docx) and Excel (.xlsx) data sourcesFree and lightweight alternative to Microsoft Office 365Intuitive Mailings tab that supports advanced merge rules
microsoft office alternative - wps office

Frequently Asked Questions

Why does Adobe PDFMaker fail on the Next Record field in Office 365?

The Acrobat PDFMaker add-in often encounters parsing limitations with complex dynamic Word fields, such as Next Record, during direct export processes. This is usually due to underlying compatibility issues between frequent Office 365 updates and the Adobe plugin engine.

Can I still generate individual PDF files for each merged record?

Yes. First, use Word's native Finish & Merge option to create a single master Word document containing all records. You can then save that document as a PDF and use a PDF splitting tool, or utilize a VBA macro within Word, to divide the master file into individual PDF documents.

How do I fix a disabled Acrobat PDFMaker add-in in Word?

If Word has disabled the add-in due to a crash, go to File > Options > Add-ins. In the Manage dropdown at the bottom, select Disabled Items and click Go. If PDFMaker is listed, select it and click Enable. Then, manage COM Add-ins to ensure it is checked.