Fix Adobe PDFMaker Not Recognizing Next Record Mail Merge Code in Word
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.

- 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.
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.
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.
In your Word document, navigate to the Mailings tab. Ignore the 'Merge to Adobe PDF' button and click the 'Finish & Merge' button instead.
Select 'Edit Individual Documents' from the dropdown menu, choose 'All' records, and click OK to generate a new, fully merged Word document.
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.

Update Office and Adobe Acrobat Add-in
Incompatibilities between newer versions of Office 365 and older Adobe PDFMaker add-ins can cause this exact mail merge limitation. Updating both applications can restore compatibility.
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. Open your Document in WPS: Launch WPS Writer and open your main mail merge template document.
- 2. Connect the Data Source: Navigate to the Mailings tab, click Open Data Source, and select your Excel spreadsheet.
- 3. Merge to New Document: Click Merge to New Document to natively process the <<Next Record>> rules into a single, comprehensive file.
- 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.

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.




