File Format & Compatibility

Fix Word Mail Merge Crashes Caused by Excel Linked Data Types

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 869 views

Question details

Prevent a Word mail merge from crashing when its Excel source contains linked data types.

Fix Word Mail Merge Crashes Caused by Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a source copy

Open the source workbook in Excel and select File > Save As to create a separate copy.

2
Convert linked cells

Select the affected cells, right-click them, and choose Data Type > Convert to Text. Repeat for other columns containing linked data types.

3
Check the merge fields

Review the converted cells in Excel, especially postal codes and locations. Confirm that leading zeros and the text needed for the merge are present.

4
Save and close the workbook

Select File > Save, then close the converted workbook in Excel.

5
Reconnect the source in Word

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.

Convert Excel Linked Data Types to Text and Reconnect Word
Test location fields separately: If the crash continues, try a small source workbook with postcode and location fields tested separately to identify the affected field.
Free Microsoft Office alternative

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.

Work with document and spreadsheet files for mail merge projectsCompatible with Microsoft Word DOCX and Excel XLSX formatsFamiliar menus make it easier to move from Microsoft OfficeFree and lightweight for everyday document editing
QA img-9

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.