Fix Word Mail Merge Crashes Caused by Excel Linked Data Types
Question details
Prevent a Word mail merge from crashing when its Excel source contains linked data types.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to merge records from an Excel workbook containing linked Geography or other linked data types into a Word document.
- Observed behavior
- Word may crash during the mail merge when the Excel source contains linked data types.
Identify the Excel columns containing linked data types, such as Geography, and check which fields the Word merge uses. Make a copy of the source workbook so you can convert its data without changing the original.
Convert Excel Linked Data Types to Text and Reconnect Word
Use a converted copy of the workbook when linked data types are causing the mail merge to crash.
Open the source workbook in Excel and select File > Save As to create a separate copy.
Select the affected cells, right-click them, and choose Data Type > Convert to Text. Repeat for other columns containing linked data types.
Review the converted cells in Excel, especially postal codes and locations. Confirm that leading zeros and the text needed for the merge are present.
Select File > Save, then close the converted workbook in Excel.
In Word, open the merge document and select Mailings > Select Recipients > Use an Existing List. Choose the converted workbook and the appropriate sheet, then use Preview Results to test the merge.

Work With Merge Documents and Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Word documents and Excel spreadsheets. Its format compatibility helps you move existing files into WPS; it does not repair a crash in Microsoft Word.

Frequently Asked Questions
How do I identify a linked Geography cell in Excel?
Look for a data type icon next to the cell value. Select a suspected cell and check its Data Type options before converting it to text.
Will converting a linked data type to text keep it linked?
No. Data Type > Convert to Text removes the linked data type from the selected cells, so use a copy if you need to keep the original linked data.
How do I reconnect the converted Excel file to Word?
In Word, select Mailings > Select Recipients > Use an Existing List, choose the saved workbook, and select the sheet containing the merge records.
What should I check if postal codes appear incorrectly?
Open the converted workbook in Excel and check the postal code column for missing leading zeros or other changes. Correct the values before saving and reconnecting the workbook in Word.




