Mail Merge Blank Records: Find and Exclude Empty Rows
If Word creates an extra letter with no recipient details, check the recipient list before changing the document layout. An empty Excel row, a selected record with missing fields, and a blank line inside an otherwise correct address are different problems. Identify which one you have before rerunning the batch.
Is it an empty record or just an empty line?
| What the output shows | What to inspect |
|---|---|
| A whole extra letter, with the normal letter text but no name | The selected recipients and the source range. |
| The right person but an empty line between address lines | An optional address field and its surrounding paragraphs. |
| Some fields filled and others missing | The specific source cells and which merge fields the template uses. |
| An extra page after a correct letter | Page or section breaks and paragraph layout in the template. |
Keep a copy of the original workbook and template. Test against a small list with a complete record, a record missing an optional field, and a deliberately empty row. Use invented test details rather than sending real customer data to an unfamiliar service.
1. Inspect the Excel source
Locate the sheet or range that Word actually uses. Give every column one clear heading and keep the recipient records together. Look below the last expected recipient for leftover rows. A row can look empty while still containing a formula, spaces or an old identifier.
Choose a required field for this batch, such as a recipient ID. An optional field, such as Address2, is a poor test for whether a record should exist: many valid recipients will not have it. If the workbook supports other work, create a separate export sheet containing only the intended records rather than deleting rows from the original.
2. Review Word’s selected recipients
In desktop Word, open Mailings → Edit Recipient List after connecting the workbook. Inspect the records and clear the selection for any unwanted entries. For a repeatable batch, use the recipient-list filter on the field that defines a valid recipient.
For example, if every intended recipient has a RecipientID, use an Is not blank condition on that field. Review the resulting list before accepting it. A row containing spaces or an ID with no name may still pass your rule; a filter is a selection instruction, not a data-quality check. Microsoft documents the available filters in Mail merge: Edit recipients.
3. Count records before producing files
Suppose your export contains 80 intended recipients and three unused rows. Your check is not “the document opens”; it is “the recipient list contains the intended 80 records, with the first and last IDs matching the export.” Preview several records, including one near the end of the list.
Complete a small merge to a document and inspect it before printing or saving a large batch. If you reconnect a different workbook or change the selected range, check the recipient list again. Do not assume that a filter you applied to the worksheet is the same as the selection Word will merge.
4. Fix optional address lines separately
A valid recipient with no second address line should normally remain in the batch. Filtering out everyone with a blank Address2 would remove legitimate recipients. Inspect the address block or the optional merge field and the paragraph around it instead. Compare the preview for one recipient with Address2 and one without it.
If all the fields are filled but a second page remains, show paragraph marks and inspect the template’s breaks. That is a layout problem, so deleting recipients will not solve it.
Questions that help narrow the fault
Does deleting a visible blank Excel row always fix it? No. Word may be using a different sheet or range, or the extra space may be part of the document layout. Verify the connected source and selected records.
Should I remove every row with any empty cell? No. Decide which fields are required. A missing optional phone number is different from a missing recipient identifier.
For adjacent problems, see numbers and dates changing in mail merge, saving separate files and the complete Excel-to-Word workflow. If you need a separate Word file or PDF for each prepared row, Docs from Excel offers a batch workflow; check the generated output and current download price before purchasing.