How to Fix Word Mail Merge Not Retrieving All Excel Records
Question details
The user needs to retrieve and merge all available records from an Excel data source, but the mail merge process is stopping after the first 30 records.
- Product
- Microsoft Word 365, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Performing a label mail merge using an Excel worksheet as the primary data source.
- Observed behavior
- Word only displays or retrieves the first 30 records from the Excel worksheet, typically corresponding to exactly one sheet of labels, and fails to process the remaining records.
Ensure your Excel data source is saved and completely closed before starting the mail merge, and verify that there are no completely blank rows interrupting the data in your worksheet.
Execute the Merge Using Finish & Merge
Use this solution if you are previewing a 30-label sheet and only seeing the first 30 records. Previewing only shows a single page of results.
When performing a label mail merge, the 'Preview Results' feature only renders the first page of your document. If your label sheet holds exactly 30 labels, previewing will give the false impression that only 30 records were retrieved from Excel. To generate all labels, you must fully execute the merge.
Open your Word document and click on the 'Mailings' tab located in the top ribbon.
Locate and click the 'Finish & Merge' dropdown button on the far right side of the Mailings ribbon.
Select 'Edit Individual Documents...' from the dropdown. In the prompt that appears, select 'All' and click OK. Word will now generate a new, multi-page document containing all the records from your Excel data source.
Correct the Next Record Field Placement
Use this method if executing the merge still yields duplicate labels or skips records entirely, which indicates an issue with the 'Next Record' field rules.
Perform Mail Merge Easily with WPS Writer
WPS Writer offers a highly intuitive and powerful Mail Merge feature that seamlessly integrates with your spreadsheets, ensuring all records are retrieved accurately without complex formatting bugs.
- 1. Open WPS Writer: Launch WPS Writer and navigate to the 'References' or 'Mailings' tab on the top ribbon.
- 2. Import Data Source: Click 'Mail Merge', then select 'Open Data Source' to browse and import your Excel spreadsheet.
- 3. Insert Merge Fields: Click 'Insert Merge Field' to place your desired data points (like Name or Address) into your document template.
- 4. Merge to New Document: Click 'Merge to Different New Document' to generate a complete file containing all populated records from your spreadsheet.
Frequently Asked Questions
Why does my mail merge skip every other record in Excel?
This usually happens if you manually added the 'Next Record' rule but also clicked 'Update Labels'. The 'Update Labels' function automatically adds its own 'Next Record' command. Having two of these commands on a single label will cause Word to advance two rows in Excel at once, skipping records.
Can blank rows in Excel cause my mail merge to stop early?
Yes. If your Excel data source contains completely blank rows, the mail merge function may interpret the first blank row it encounters as the end of the database. Ensure you delete any empty rows in your Excel file before starting the merge.
How do I filter out specific Excel records during a mail merge?
On the Mailings tab, click 'Edit Recipient List'. This opens a dialog box where you can uncheck specific rows, sort your data, or use the Filter option to only include records that meet certain criteria (e.g., specific zip codes) without modifying the original Excel file.
