You run a mail merge in Word and the resulting documents show blank fields where names, addresses, or other data should appear. This usually happens because the data source — an Excel file, Outlook contacts, or a database — is not properly connected to Word or because field codes are mismatched. This article explains the three most common causes of blank mail merge fields and provides step-by-step fixes for each scenario.
Key Takeaways: How to Fix Blank Fields in a Word Mail Merge
- Mailings > Start Mail Merge > Select Recipients > Use an Existing List: Reconnect a disconnected data source to repopulate all fields.
- Mailings > Edit Recipient List > Data Source > Check the header row: Ensure the first row of your Excel sheet contains column names that match the merge fields in Word.
- Mailings > Preview Results: Toggle this button on and off to refresh the display and reveal hidden blank fields caused by field code corruption.
Why Mail Merge Fields Show Up Blank in Word
A Word mail merge pulls data from an external source — typically an Excel file, a CSV file, or an Outlook contact list. When the fields appear blank, the problem is almost always one of three things:
The Data Source Connection Is Broken
Word stores a path to the data source file. If you move, rename, or delete that file, Word cannot read the data. The merge fields still exist in the document but display as blank because no data is being fed into them.
Column Names Do Not Match the Merge Fields
Word uses the column headers from the first row of your data source to populate the merge fields. If a column header is missing, misspelled, or contains extra spaces, Word cannot map the data to the correct field. For example, a column named “First Name ” with a trailing space will not match the merge field «First_Name».
Field Codes Are Corrupted or Hidden
Each merge field in Word is actually a field code — a small piece of code that tells Word which data column to use. If these codes become corrupted, or if the document view is set to show field codes instead of their results, the fields will appear blank.
Steps to Fix Blank Fields in a Mail Merge
Method 1: Reconnect the Data Source
- Open the mail merge document in Word
Make sure the document is the one you used for the merge. Do not create a new document from scratch. - Go to Mailings > Select Recipients
Click the “Select Recipients” button in the Start Mail Merge group. - Choose “Use an Existing List”
A file dialog opens. Browse to the correct data source file — your Excel workbook, CSV file, or Access database. - Select the correct table or sheet
If the data source contains multiple sheets or tables, Word will ask you to pick one. Choose the sheet or table that contains your data. - Click OK
Word reconnects to the data source. The merge fields should now display data when you click Preview Results.
Method 2: Verify the Data Source Header Row
- Open your data source file in its native application
If you are using an Excel file, open it in Excel. Do not edit the file while Word has it open — close the mail merge document first. - Check the first row for column headers
Each column must have a unique name in the first row. Remove any blank cells in the first row. Delete extra spaces before or after the column names. - Ensure column names match the merge field names in Word
Word uses the exact text from the first row. If a column is named “Address” but your merge field is «FullAddress», the field will be blank. Rename the column in the data source to match the merge field, or insert a new merge field in Word that matches the column name. - Save the data source file and close it
Return to Word and reconnect the data source using Method 1 steps 2 through 5.
Method 3: Toggle Field Codes and Preview Results
- In the mail merge document, press Alt+F9
This toggles the display between field codes and field results. If you see text like { MERGEFIELD First_Name }, you are viewing field codes. Press Alt+F9 again to return to results. - Click Preview Results in the Mailings tab
The Preview Results button is in the Preview Results group. Click it once to turn on preview. Word shows the first record from your data source. - Use the arrow buttons to cycle through records
If some records show data and others show blanks, the problem is in the data source — not in Word. Open the data source and check for missing values in those specific rows. - If fields remain blank, delete and reinsert the merge field
Click the blank merge field. Press Delete. Then go to Mailings > Insert Merge Field and select the same field from the list. Repeat for all blank fields.
If Mail Merge Still Shows Blank Fields After the Main Fix
Blank Fields Appear Only in the Final Merged Document
The preview shows data correctly, but the final merged document has blanks. This usually means the data source contains empty cells. Open the data source in Excel. Sort each column to find blank cells and fill them with a placeholder value like “N/A” or remove those rows from the merge.
Word Says “Word Cannot Open the Data Source”
This error appears when the file is locked by another user, the file is in an unsupported format, or the file path is too long. Save a copy of the data source as a .csv file. Shorten the file name and move it to a folder close to the root of the drive, such as C:\Merge\. Then reconnect using Method 1.
Merge Fields Show as ««First_Name»» With Double Angle Brackets
Double brackets mean Word is treating the merge field as plain text, not as a field code. Delete the entire text including the brackets. Reinsert the merge field using Mailings > Insert Merge Field.
Word Mail Merge Data Sources: File Type Differences That Affect Blank Fields
| Feature | Excel (.xlsx) | CSV (.csv) |
|---|---|---|
| Header row detection | Word uses the first row automatically | Word uses the first row automatically |
| Column name handling | Accepts spaces and special characters | Removes spaces; converts commas to underscores |
| Blank cell behavior | Shows blank in merged document | Shows blank in merged document |
| File path sensitivity | Breaks if file is moved or renamed | Breaks if file is moved or renamed |
| Recommended for | Complex data with multiple sheets | Simple lists; avoids formatting conflicts |
When blank fields persist, convert your Excel file to CSV format. Open the Excel file in Excel. Click File > Save As. Choose CSV UTF-8 (Comma delimited) as the file type. Close Excel. Reconnect the CSV file in Word using Method 1. CSV files are less likely to cause field mapping issues because they strip out hidden formatting and special characters.
After fixing the blank fields, run a test merge to a new document before merging to a printer or email. Click Finish & Merge > Edit Individual Documents. Choose Current Record and click OK. Review the output for any remaining blank fields. If you find none, run the full merge.