Fix Word Mail Merge Showing Empty Data Records After Preview
Question details
The user experiences an issue where a Word mail merge displays data correctly during the preview stage, but outputs empty data records in the final merged document.
- Product
- Microsoft Word, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Completing a mail merge to generate letters or documents using an Excel data source or a document table.
- Observed behavior
- The preview step shows the correct merged data, but the final completed merge results in blank or empty data records.
Ensure your Excel data source is closed before running the mail merge in Word, and verify that your spreadsheet column headers do not contain special characters or spaces.
Verify Data Source Connection and Re-insert Merge Fields
Check the connection between your Word document and Excel data source, and ensure that the merge fields correctly correspond to valid, non-empty records.
Sometimes the connection to the data source drops or becomes corrupted right before the final merge execution, causing the engine to pull blank fields even if the preview cache looked correct.
Open your Word mail merge main document and navigate to the 'Mailings' tab on the ribbon. Click 'Select Recipients' and choose 'Use an Existing List' to reconnect your Excel data source, ensuring the correct sheet is selected.
Highlight the problematic merge fields in your document, delete them, and click 'Insert Merge Field' to add them back directly from the newly connected source.
Click 'Preview Results' to verify the data. Next, select 'Finish & Merge' and choose 'Edit Individual Documents'. This creates a new document where you can check if the final output populates correctly before printing.
Convert Excel Data Source to CSV Format
Saving your data source as a CSV file can strip away underlying formatting issues that cause Word to misread the records during the final merge.
Perform Flawless Mail Merges with WPS Writer
Avoid empty data records and preview glitches by using WPS Writer for your mail merge tasks. WPS Office provides a stable, intuitive mail merge feature that flawlessly connects with spreadsheets to generate your letters, labels, and emails without data loss.
- 1. Open Your Document: Launch WPS Writer and create or open your main template document.
- 2. Access Mail Merge: Navigate to the 'References' or 'Mailings' tab on the top ribbon and click on 'Mail Merge'.
- 3. Connect Your Data: Select 'Open Data Source' and choose your spreadsheet containing the records.
- 4. Insert Fields and Complete: Use 'Insert Merge Field' to place your data variables into the document, then click 'Merge to New Document' to complete the task with populated records.
Frequently Asked Questions
Why does my Word mail merge show data in preview but not in print?
This typically happens if the connection to the data source drops during the merge process, or if the document contains corrupt merge fields. Reconnecting the Excel file and re-inserting the fields often resolves it.
Can hidden columns in Excel cause empty mail merge records?
Yes, hidden columns, active filters, or merged cells in the header row of your Excel data source can confuse Word's mail merge engine, leading to blank outputs. Unhide all data and remove merged cells before starting your merge.
How do I fix a mail merge that skips records?
Check your Word document for unintended 'Next Record' rules. You can find these under the 'Rules' dropdown in the Mailings tab. Extraneous 'Next Record' commands will cause the merge to skip lines of data.
