After converting a mail merge document to plain text or saving it as a new file, you may find that some table cells appear completely empty. This happens even though the original merge fields contained data. The problem is caused by leftover merge field codes or paragraph marks that Word cannot display correctly after the merge conversion. This article explains why empty cells appear and provides a step-by-step method to restore the visible content.
Key Takeaways: Fixing Empty Table Cells After Mail Merge Conversion
- Alt+F9 to toggle field code display: Reveals hidden merge field codes that can cause empty cells after conversion.
- Ctrl+Shift+F9 to unlink fields: Replaces merge field codes with their current values permanently.
- Find and Replace with ^p and ^l: Removes extra paragraph and line breaks that push cell content out of view.
Why Merge Field Codes Cause Empty Cells After Conversion
When you perform a mail merge in Word, each merge field such as «FirstName» is represented by a complex field code. After you complete the merge and choose to edit individual documents or save the results, Word converts these field codes into the actual data from your data source. However, the conversion process does not always clean up the underlying field codes. If the field codes remain but display no visible text, the cell appears empty.
The Role of Field Code Toggling
By default, Word shows the result of a field code, not the code itself. When you convert a merged document, Word may toggle the display to show the field code instead of the result. If the field code contains no visible text or if the result is blank, the cell will look empty. Pressing Alt+F9 switches between showing field codes and their results. If you see text like { MERGEFIELD FirstName } in the cell, the field code is still active and not properly converted.
Leftover Paragraph Marks and Line Breaks
Another cause is extra paragraph marks (^p) or manual line breaks (^l) that remain after the merge. These invisible characters can push the cell content down or hide it behind the cell boundary. Word may still store the data, but the formatting marks prevent it from displaying.
Steps to Restore Content in Empty Table Cells
- Toggle field codes to inspect the cell
Select the entire table by clicking the small square icon at the top-left corner of the table. Press Alt+F9 on your keyboard. If you see field codes like { MERGEFIELD FirstName } inside the cells, the data has not been converted to plain text. Press Alt+F9 again to return to the result view. - Unlink all merge fields
With the table still selected, press Ctrl+Shift+F9. This command unlinks all field codes in the selection and replaces them with their current values. The data becomes static text. After this step, empty cells should now show the correct content. - Remove extra paragraph marks inside cells
Press Ctrl+H to open the Find and Replace dialog. In the Find what box, type ^p (without quotes). In the Replace with box, type a single space. Click Replace All. This removes extra paragraph marks that may hide content. Repeat the process with ^l in the Find what box to remove manual line breaks. - Clear direct formatting from the cell
Select the empty cell. On the Home tab, click the Clear button in the Editing group and choose Clear Formats. This removes any hidden font settings that make the text invisible, such as white font color or zero-point font size. - Check the cell shading and borders
Right-click the empty cell and select Borders and Shading. On the Shading tab, confirm that the Fill color is set to No Color. A dark cell fill can hide text. On the Borders tab, ensure the cell has visible borders so you can see if the content is present but not displayed.
If Word Still Has Issues After the Main Fix
Empty cells appear only in specific columns
If certain columns remain empty while others show data, the problem is likely a mismatch between the merge field name and the data source column header. Open your original data source, such as an Excel file or Access database, and verify that the column name exactly matches the merge field name used in Word. Correct any spelling differences and rerun the mail merge.
Cells show only a single character or symbol
This usually indicates that the cell contains a non-breaking space (Alt+0160) or a special character instead of the actual data. Select the cell and press Delete to remove the character. Then, reinsert the merge field from the Mailings tab and run the merge again.
Entire table disappears after unlinking fields
If the table itself vanishes after you press Ctrl+Shift+F9, the table was likely nested inside a field code. Before unlinking, copy the entire table to the clipboard by selecting it and pressing Ctrl+C. Paste it into a new blank document using Paste Special and choose Unformatted Text. Then apply table formatting again.
| Item | Field Code Active | Field Code Unlinked |
|---|---|---|
| Display type | Shows { MERGEFIELD … } or blank | Shows actual data from the source |
| Editable | Cannot edit directly; must update source | Fully editable as plain text |
| After saving and reopening | May revert to field code display | Retains data permanently |
| Recommended for final document | No | Yes |
After unlinking fields, the document becomes static and no longer updates from the data source. Keep a copy of the original merged document if you need to rerun the merge later.