Mail merge from Word to PDF hangs - "Inconsistencies in the database"

[defaultf38yxn0adrdt]

Running a mail merge from word 2010 to PDF. It keeps hanging and giving me a message "Acrobat PDFMaker has found inconsistencies in the database. Please make sure there are no blank records or email fields in the database"

I've never seen this before. There are no blank records. And of course there are email fields! I've run merges before with email fields, and with no problem. I don't understand what's happening or how to fix it.

Please help.

[Kim22488330hl31]

ANY LUCK ON FIXING THIS!?! I am having the same issue no idea what to do...

[Trevor22628857x5rg · Accepted solution]

I don't know if we'll have the same fix, but I was getting frustrated with the same thing! 

When I ran a preview and viewed the last recipient the merge fields were left blank. Apparently, Word was reading beyond the table in my sheet, and that was creating the error for the blank records...

To fix it I just selected one row below my data, SHIFT + CTRL + Down Arrow, and deleted it. I did the same thing for the columns next to my data. After that, it created the merge and allowed me to convert it to a PDF. 

Hopefully, this helps! 

[Rebecca247663197yi4]

Thank you SO much for this suggestion!  I was so frustrated with a merge that was not working.  I followed your suggestion of deleting fields below and next to those being pulled from the spreadsheet but was still getting an error message.  I started the whole merge again and previewed recipients and found that it was pulling blank fields from an unexpected portion of the sheet so I excluded those recipients using the checkboxes in the Word recipient list and got it to work.  Thanks again!

[Gregory284304683qdv]

Oh my - thank you so much for this added tip! I was aboutt o throw my computer out the window! 

[Raihan270634196xf9]

THANK YOU SO MUCHH BROOO, IT HELPS ME AFTER 2 HOURS FINDING IT, i find it i cant even send 1000 emails my self T-T. Thank you once again

[milica_9095]

Dear Trevor22628857x5rg • you are a saviour, this fixed my issue and I was getting the same error as listed above. THANKS!