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
  • 8604 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

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
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
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
Community Expert
May 14, 2020

Ok, can you describe the steps that you 're following after the file in Excel is saved?

 

Are you exporting an MS Excel workbook to PDF before the merge? or are you trying to use MS Excel data directly in MS Word to fill out the Mail Merge template fields?