How to Fix Word Mail Merge Cannot Finish or Print Merged Documents
Question details
The user is unable to finish a mail merge or print the resulting merged documents in Microsoft Word.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Attempting to finalize a mail merge or print the merged documents using an Excel data source.
- Observed behavior
- Word fails to complete the 'Finish & Merge' action or fails to print, often caused by special characters in the data source, unsupported fonts, or application version issues.
Ensure your Microsoft Word application is updated to the latest version and create a backup copy of your Excel data source before making any modifications.
Clean Up the Excel Data Source
Remove special characters and double quotation marks from your Excel data source, as they often interrupt the data parsing during the mail merge process.
Hidden formatting, double quotation marks, or non-printable special characters in your Excel spreadsheet are the most common culprits for mail merge failures. Cleaning these characters allows Word to read the data correctly.
Open the Excel workbook that you are using as the data source for your mail merge.
Press 'Ctrl + H' to open the Find and Replace dialog box.
In the 'Find what' field, type a double quotation mark ("). Leave the 'Replace with' field completely empty, and click 'Replace All'.
Manually inspect your data or use the CLEAN function in Excel to remove any non-printable characters from your text fields.
Save the cleaned Excel file. Open your Word document, navigate to the 'Mailings' tab, click 'Select Recipients', and reconnect to the updated list.
Change the Document Font
Certain unsupported, downloaded, or corrupted fonts in the Word template can cause the print spooler or the merge process to fail.
Test with a Simplified Data Set
Isolate the issue by testing the mail merge with a very small portion of your data to determine if a specific row is causing the crash.
Easily Complete Mail Merge with WPS Office
If Microsoft Word continues to crash or fail during your mail merge, you can seamlessly open your Word template and Excel data source in WPS Office to finish the job for free. WPS Office offers a robust and user-friendly mail merge tool.
- 1. Open Document in WPS: Launch WPS Writer and open your existing Word mail merge document (.docx).
- 2. Access Mail Merge: Navigate to the 'References' tab on the top ribbon and click on 'Mail Merge'.
- 3. Connect Data Source: Click 'Open Data Source' and select your Excel spreadsheet containing the contact list.
- 4. Finish and Print: Click 'Merge to Printer' or 'Merge to New Document' to finalize your mail merge seamlessly without freezing.
Frequently Asked Questions
Why does Word freeze when I click Finish & Merge?
Word often freezes during Finish & Merge if the connected Excel file is too large, contains hidden formatting errors, or includes unsupported special characters (like unescaped double quotes) in the data fields.
Can I skip specific corrupted rows in my data source without deleting them?
Yes. In Word, go to the 'Mailings' tab, click 'Edit Recipient List', and simply uncheck the boxes next to the rows you suspect are causing the mail merge failure.
Does the file format of my data source matter for Mail Merge?
Yes. Older formats like .xls or CSV files with incorrect delimiters can sometimes cause data parsing issues. Saving your data source as a standard .xlsx file ensures better stability.
How do I know if a specific font is causing my mail merge to fail?
If the merge works when outputting to a new document but fails specifically when sending it to the printer or saving as a PDF, a corrupted or unsupported font is likely the cause. Try switching the entire document to Arial or Calibri to test.
