Data Import & Export

Fix Excel Mail Merge Values Showing as 0 or Blank in Word

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

The user needs Excel values, including text such as Cr, to appear correctly in a Word mail merge.

Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A Word mail merge uses an Excel worksheet as its recipient data source.
Observed behavior
Some values that display correctly in Excel appear as zero or blank in the merged Word document.
Before you start

Open the Excel worksheet and select affected cells to compare their displayed contents with the values in the formula bar. Make sure the first row contains clear column headers and note which columns have mixed text and numbers.

Solution 1Recommended

Reconnect the Excel data source through DDE

Use DDE in desktop Word for Windows when the usual Excel connection does not merge displayed values as expected.

Word may read an underlying cell value differently from how Excel displays it. A DDE connection can help Word retrieve Excel data through Excel, but results depend on the workbook and the values involved.

1
Enable conversion prompts

In Word, go to File > Options > Advanced. Under General, select Confirm file format conversion on open, then click OK.

2
Select the workbook again

Open the merge document and choose Mailings > Select Recipients > Use an Existing List. Select the Excel workbook.

3
Choose the DDE connection

In the Confirm Data Source dialog, select Show all if needed, then choose Microsoft Excel Worksheets via DDE and click OK. Select the worksheet or range when prompted.

4
Preview the merged values

Choose Mailings > Preview Results and move through the records to check the affected fields. Use Finish & Merge when the values are correct.

Reconnecting may be necessary: Word may ask you to reconnect the Excel data source when you reopen the merge document. If DDE is unavailable, check the source data and use an available Excel connection instead.
Free Microsoft Office alternative

Work with spreadsheets and documents in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Excel spreadsheets and Word documents. Open compatible files in WPS to continue your work with less friction, although it does not fix Word's DDE connection.

Review spreadsheet values alongside documents used for mailingsCompatible with Microsoft Excel XLSX and Word DOCX formatsFamiliar document and spreadsheet tools make migration easierFree and lightweight for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Why does Word show 0 when Excel displays Cr?

The cell may contain a numeric value that Excel displays as Cr through formatting, or Word may interpret the source column differently. Select the cell in Excel and check the formula bar to see its underlying value.

Where do I enable the option to choose DDE in Word?

In desktop Word for Windows, go to File > Options > Advanced. Under General, select Confirm file format conversion on open. Then reconnect the workbook through Mailings > Select Recipients > Use an Existing List.

What if Microsoft Excel Worksheets via DDE does not appear?

In the Confirm Data Source dialog, select Show all if it is available. DDE support depends on the Word and Excel environment; if the option still does not appear, check the source values and connect using an available Excel method.

Why does Word ask me to reconnect the workbook when I reopen the merge?

A DDE-based merge may prompt you to reconnect its Excel data source when the document opens. Follow Word's prompt and select the workbook again, then use Mailings > Preview Results to verify the fields.