Fix Excel Mail Merge Values Showing as 0 or Blank in Word
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.
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.
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.
In Word, go to File > Options > Advanced. Under General, select Confirm file format conversion on open, then click OK.
Open the merge document and choose Mailings > Select Recipients > Use an Existing List. Select the Excel workbook.
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.
Choose Mailings > Preview Results and move through the records to check the affected fields. Use Finish & Merge when the values are correct.
Check and standardize the Excel source values
Use this approach if affected cells contain mixed data types or rely on formatting to display text.
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.

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.




