Fix Word Mail Merge Emails Sent to the Wrong Recipients
Question details
The user needs to prevent Word mail merge emails from using information or addresses from the wrong Excel records.
- Product
- Microsoft Word Mail Merge and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sending personalized email messages from a Word document linked to an Excel recipient list.
- Observed behavior
- Messages may use details from the next person in the Excel list when a Next Record If field advances the merge record.
Open the Word mail merge document and its Excel recipient list. Identify the email address column and check whether the document contains a Next Record If rule.
Remove the Next Record If rule and verify the merge
Use this approach when messages appear to use details from the next row in the recipient list.
A Next Record If field advances Word to the next data record when its condition is true. It is usually unnecessary when creating one personalized email per recipient.
Open the main document in Word and look for a Next Record If field where the recipient details begin to shift. On Windows, press Alt+F9 to display field codes and look for NEXTIF.
Select and delete the complete NEXTIF field, including its condition, if it is not needed. On Windows, press Alt+F9 again to return to the normal field display.
Go to Mailings > Edit Recipient List and confirm that the intended Excel data source and recipients are selected. In Excel, check that each person's email address and other details are on the same row.
In Word, select Mailings > Preview Results and use the record arrows to check that each person's details stay together, especially around the rows where the shift occurred.
Connect a test copy of the data source containing addresses you control, then choose Mailings > Finish & Merge > Send Email Messages. Select the correct email address column in the To field and verify the received messages before reconnecting the original list.
Edit recipient lists and documents with WPS Office
WPS Office is a free, lightweight, easy-to-use alternative for working with documents and spreadsheets in a familiar interface. Its Microsoft Office format compatibility helps you move existing files across, although it does not fix Word's mail merge field behavior.
Frequently Asked Questions
Why is Word using the next person's data in my email?
A Next Record If field may advance the merge when its condition is true. Inspect the document for the NEXTIF field and remove it if the rule is not needed.
How do I check which email column Word will use?
Choose Mailings > Finish & Merge > Send Email Messages and check the To field. Select the column in your data source that contains the intended email addresses.
Can I preview the merge before sending emails?
Yes. Select Mailings > Preview Results and use the record arrows to inspect several recipients. For an end-to-end check, send a small merge using a test data source with addresses you control.
What should I check in the Excel recipient list?
Open the Excel source and confirm that each recipient's email address and personal details are on the same row. In Word, use Mailings > Edit Recipient List to verify the selected source and recipients.
