Document Editing Problems

Fix a Word Directory Mail Merge That Shows Only the Last Excel Record

Steve KSteve K Nov 18, 2026 869 views

Question details

The user needs a Word directory mail merge to include all Excel records sequentially rather than showing only the final record.

Fix a Word Directory Mail Merge That Shows Only the Last Excel 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.
Before you start

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.

Solution 1Recommended

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.

1
Choose the merge type

In Word, open the main merge document and select Mailings > Start Mail Merge > Directory.

2
Check the recipient list

Select Mailings > Edit Recipient List and confirm that the intended records are selected and that filters are not excluding them.

3
Merge every record

Select Mailings > Finish & Merge > Edit Individual Documents, choose All, and select OK.

4
Review the output

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.

Merge all records with the Directory document type
Free Microsoft Office alternative

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.

Work with Word DOCX documents and Excel XLSX spreadsheetsUse a familiar interface for everyday document and spreadsheet editingOpen and review directory documents and their source data in one office suiteMove existing files into a free, lightweight office alternative
microsoft office alternative - wps office

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.