Fix a Word Directory Mail Merge That Shows Only the Last Excel Record
Question details
The user needs a Word directory mail merge to include all Excel records sequentially rather than showing only the final record.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A directory document uses an Excel worksheet as its mail merge data source and may contain complex fields or require grouped records.
- Observed behavior
- The merged directory displays only the final Excel record.
Check that the Excel source has clear field names in the first row and that each record occupies its own row. Identify the worksheet containing the records so you can select it when connecting the data source.
Merge all records with the Directory document type
Use this when Word may be merging a single selected record or using the wrong document type.
In Word, open the main merge document and select Mailings > Start Mail Merge > Directory.
Select Mailings > Edit Recipient List and confirm that the intended records are selected and that filters are not excluding them.
Select Mailings > Finish & Merge > Edit Individual Documents, choose All, and select OK.
In the new merged document, check that records appear sequentially. If only one appears, return to the main document and test with a simple layout containing only the necessary merge fields.

Create the directory separately and insert it into the longer document
Use a separate merge document when the directory must follow existing pages or when you need to isolate complex fields.
Use a many-to-one merge tool for grouped records
Use a compatible many-to-one merge tool when several Excel rows must appear together in one invoice or other grouped output.
Explore WPS Office for documents and spreadsheet data
WPS Office is a free, lightweight alternative with a familiar interface and support for common Word and Excel formats, making it easier to move existing documents and spreadsheets into WPS. It does not fix Word-specific merge settings or guarantee compatibility with complex merge fields.

Frequently Asked Questions
Why did Word merge only one Excel record?
A single record may have been selected during the merge, or recipient filters may be excluding others. Check Mailings > Edit Recipient List, then select Finish & Merge > Edit Individual Documents > All.
Which Word mail merge type lists records sequentially?
Select Mailings > Start Mail Merge > Directory. Then merge to a new document and choose All to include the selected records.
Does the Excel data have to be on the first worksheet?
No. When connecting the Excel file through Mailings > Select Recipients > Use an Existing List, select the worksheet containing the records. Put clear field names in its first row.
Can a directory merge group several rows into one invoice?
A standard directory merge lists records sequentially and may not support the required many-to-one layout. For grouped invoices, consider a compatible many-to-one merge tool that groups rows by an invoice or customer ID.
How can I place the directory after existing pages?
Merge the directory into a separate document and save it. In the longer document, place the cursor at the insertion point and select Insert > Object > Text from File.




