Skip to main content
LeeTay
Known Participant
May 14, 2020
Question

PDFMaker doesn't recognize [next record] Word mail merge code when merging to PDF

  • May 14, 2020
  • 4 replies
  • 8494 views

A procedure that we've been using for months has suddenly stopped working. Word mail merge to PDF is throwing an error: it's not recognizing <<next record>> as a legit merge code.

 

We're running Office 365 on Win10, all updates applied.

 

I'm running a Word mail merge, with data sourced from an Excel worksheet. I'm trying to run the merge directly to PDF, per the "Merge to Adobe PDF" function. (We run this particular merge frequently, but this is the first time it has failed.)


We're getting an Adobe error message that the <<next record>> merge code is not valid. We've deleted the <<next record>> merge code and re-run the merge-to-PDF, but we still get the Adobe error message - even though the code is no longer in the document. We've created a copy of the Merge master .docx - Adobe still throws the error.

 

We can, however, use the Word merge function to create a new document containing merged records, and that works fine.

 

Both Word and Adobe have been updated and are current. I also did the Adobe PDF repair procedure suggested in another topic.

This topic has been closed for replies.

4 replies

New Participant
February 16, 2022

Hi Lee, 

I just now ran into the same problem, and I found the solution.
When you want to export to PDF, do not use the "Merge to Adobe PDF" button. Instead use "Finish & Merge" button right next to it, on the left. It will let you save as a PDF at the end, and it works all the same.

I watched this guy on youtube: https://www.youtube.com/watch?v=dGN9LETRiQI

Hope I this helps anyone in the future.

Participating Frequently
July 6, 2021

Thank you for posting, I'm having the same very frustrating issue.  Can't merge if the "{Next}" tag is in the document.

ls_rbls
Community Expert
May 15, 2020

Not sure what could be the issue.

 

From what you've shared, I am inclined to think that after an update (or upgrade ) a compatibility issue popped.

 

I think the current Adobe PDF Maker add-in is not compatible with your Office 365.

 

You're not the first user that I've tried to help that has confirmed  unexpected issues with the MS Word mail merge, specially if it was working before.

 

According to Adobe Helpx guidance this seems to be a known issue.

 

See here: https://helpx.adobe.com/acrobat/kb/troubleshoot-acrobat-pdfmaker-problems-office.html#temp_problem 

 

And here is Microsoft guidance on how to also troubleshoot the PDF Maker add-in:

 

https://docs.microsoft.com/en-us/office/troubleshoot/miscellaneous/incompatibilities-between-office-and-adob 

 

https://docs.microsoft.com/en-us/officeupdates/release-notes-microsoft365-apps 

 

Additional tips:

 

https://support.office.com/en-us/article/get-the-adobe-acrobat-tab-to-appear-b83cbba3-7bc1-4c75-b8dc-511e07a283f0 

ls_rbls
Community Expert
May 14, 2020

Can you please share a screenshot of the error?

LeeTay
LeeTayAuthor
Known Participant
May 14, 2020

 

ls_rbls
Community Expert
May 15, 2020

I'm not exporting anything to Excel.

An Excel spreadsheet is the data source for the Word mail merge.

The steps are the usual ones:

  1. Open the merge master file in Word.
  2. Under Mailings, select the Merge to Adobe PDF function.
  3. Select the records to include.
  4. Receive error message above.

We have run this same process with these same Word and Excel files dozens of times in the last several months. The error started showing up today.


So as I am reading, have you use the remove duplicates feature in Excel, that is just an idea.

 

The other suggestion, is this excel data source saved in the same location as before? or is it saved at an HTTP location?

 

See these Microsoft guidance : https://support.office.com/en-us/article/prepare-your-excel-data-source-for-a-word-mail-merge-2d802b6b-a3a3-43e5-bb76-2cac7c68673e

 

And check if any steps were skipped.