When you run a mail merge in Word and select a specific record, the preview pane still shows the first record instead of the one you chose. This problem usually occurs because the mail merge preview is tied to the main document’s field codes, not the selected data source row. The issue can also stem from a corrupted merge field or a mismatch between the document and the data source. This article explains why the preview fails and provides step-by-step fixes to make the preview show the correct record.
Key Takeaways: Fixing Mail Merge Preview Showing Wrong Record
- Mailings > Preview Results > Preview Results button: Toggles the preview on and off; turning it off then on again often forces the preview to refresh and show the selected record.
- Mailings > Finish & Merge > Edit Individual Documents: Creates a new document with all records; if the preview still shows the first record, this confirms the data source is intact and the issue is in the preview rendering.
- Alt+F9 to toggle field codes: Reveals hidden merge field codes; if a field is not updating, toggling codes and pressing F9 updates the field and can fix the preview.
Why the Mail Merge Preview Shows the First Record Instead of the Selected One
The mail merge preview in Word relies on the document’s field codes to pull data from the connected data source. When you select a specific record using the arrow buttons or the Find Recipient dialog, Word is supposed to update the preview to show that record’s data. However, several conditions can break this link:
- Field code corruption: A merge field may have become disconnected from the data source, causing it to always display the first record’s value.
- Data source connection loss: If the data source file (Excel, Access, or Outlook contacts) has been moved, renamed, or closed, Word cannot fetch the selected record and falls back to the first record.
- Preview toggle state: The Preview Results button must be active for the preview to update; if it is off, Word shows placeholder text like «FirstName» instead of actual data.
- Document corruption: The mail merge main document itself may have internal corruption that prevents it from responding to record selection changes.
Understanding these causes helps you choose the right fix. The steps below address each scenario, starting with the simplest refresh and moving to more advanced repairs.
Steps to Force Word Mail Merge Preview to Show the Selected Record
Follow these steps in order. After each step, test the preview by clicking a different record arrow in the Preview Results group on the Mailings tab.
- Toggle the Preview Results button off and on
Go to the Mailings tab. In the Preview Results group, click Preview Results to turn it off. The document will show field codes like «FirstName». Click Preview Results again to turn it on. This action forces Word to re-evaluate the current record selection and refresh the display. - Use the Find Recipient feature to reselect the record
In the Preview Results group, click Find Recipient. In the dialog, enter a value that uniquely identifies the record you want, such as an email address or last name. Click Find Next and then Close. This often resets the internal record pointer. - Navigate records using the arrow buttons
In the Preview Results group, click the Next Record arrow (right-pointing triangle) to move to the next record, then click the Previous Record arrow (left-pointing triangle) to return. This manual walkthrough can force the preview to update. - Check the data source connection
Go to Mailings > Select Recipients > Use an Existing List. Browse to the data source file and select it again. If the file has been moved, this step reconnects the document to the correct file. After reconnecting, repeat step 1. - Toggle field codes and update all fields
Press Alt+F9 to show field codes in the document. You will see codes like { MERGEFIELD FirstName }. Press Ctrl+A to select the entire document, then press F9 to update all fields. Press Alt+F9 again to hide field codes. This refreshes every merge field and often resolves display issues. - Create a new mail merge main document
If none of the above works, the main document may be corrupted. Open a new blank document. Go to Mailings > Start Mail Merge > Step-by-Step Mail Merge Wizard. Recreate the merge from scratch, using the same data source. This is the most reliable fix for deeply corrupted documents.
If the Mail Merge Preview Still Shows the First Record
Word shows the first record for all records when I use Excel as the data source
When the data source is an Excel worksheet, the most common cause is that the worksheet contains empty rows or columns within the data range. Word interprets these as the end of the data, so it only sees the first row. Open the Excel file, select the entire data range, and press Ctrl+T to create a table. Save the file. In Word, go to Mailings > Select Recipients > Use an Existing List and select the table (not the worksheet) from the Select Table dialog.
The preview shows the first record even after I edit the data source
Word caches the data source metadata. After editing the data source, close Word completely. Reopen the mail merge document. Word will reload the data source from the file. If the issue persists, delete and re-add the data source using Mailings > Select Recipients > Use an Existing List.
Merge fields display as «FirstName» instead of actual data
This means the Preview Results button is turned off. Click Preview Results in the Mailings tab to turn it on. If the button is already on but fields still show as codes, press Alt+F9 to toggle field code display off.
Word crashes or freezes when I try to preview a specific record
A single record in the data source may contain corrupt or extremely long data (e.g., a 50,000-character text field). Open the data source, locate that record, and shorten or clear the problematic field. Save the file and retry the mail merge in Word.
Mail Merge Preview Behavior: Word Desktop vs Word for the Web
| Item | Word Desktop (Microsoft 365 / 2021) | Word for the Web |
|---|---|---|
| Preview Results button availability | Full control with Preview Results toggle, arrows, and Find Recipient | Preview Results button exists but limited; no Find Recipient dialog |
| Record selection persistence | Selection persists across saves and closes | Selection resets to first record after page refresh |
| Field code toggling (Alt+F9) | Supported | Not supported |
| Data source reconnection | Manual via Select Recipients | Automatic but limited to cloud-stored files (OneDrive, SharePoint) |
| Handling of empty rows in Excel | Stops data import at first empty row | Same behavior |
Word for the Web is not recommended for complex mail merges with many records because it lacks the field code troubleshooting tools and the Find Recipient feature. Use Word Desktop for reliable preview control.
You can now force the mail merge preview to show the selected record by toggling the Preview Results button, reconnecting the data source, or updating field codes with F9. If the problem persists, create a new main document using the Step-by-Step Mail Merge Wizard. For future merges, always store the data source file in a fixed folder and avoid renaming it after the merge is set up. Use the Edit Individual Documents command under Finish & Merge to generate a single document with all records as a final check before printing or emailing.