Document Editing Problems

How to Skip Blank or Nonblank Records in Word Mail Merge

Phi Hung VoPhi Hung Vo Nov 3, 2026 869 views

Question details

The user wants to generate mail-merge labels or letters exclusively for spreadsheet records that meet a specific condition, such as skipping contacts missing an email address.

How to Skip Blank or Nonblank Records in a Word Mail Merge
Product
Microsoft Word
Device & OS
not provided
Scenario
Generating mail-merge labels or letters where certain records need to be excluded based on missing or present data in a specific column.
Observed behavior
The recipient list is successfully filtered so that only records with or without an email address are merged into the final document.
Before you start

Ensure your data source spreadsheet is saved, closed, and formatted with clear column headers (like 'Email' or 'Address') before initiating the mail merge.

Solution 1Recommended

Filter Blank Records Using the Edit Recipient List Feature

This built-in feature allows you to quickly filter out blank or nonblank records directly within the word processor without altering your original spreadsheet data.

The most straightforward way to skip certain records is by applying a filter within the Mail Merge Recipients dialog box. This instructs the software to ignore any rows that do not meet your criteria during the merge process.

1
Open Edit Recipient List

Navigate to the Mailings tab on the top ribbon and click on 'Edit Recipient List' after linking your data source.

2
Access Filter Options

In the Mail Merge Recipients dialog box, click on the 'Filter...' link located in the Refine recipient list section.

3
Set the Condition

Under the Field column, select your target column (e.g., Email). Under Comparison, choose 'Is Blank' (to find missing emails) or 'Is Not Blank' (to skip missing emails), and click OK to apply the filter.

Filter Blank Records Using the Edit Recipient List Feature
Data Safety: Filtering records here only hides them from the current mail merge. It does not delete or modify the data in your original spreadsheet.
Efficient Document Processing

Perform Seamless Mail Merges with WPS Office

WPS Writer offers a robust and user-friendly Mail Merge feature, fully compatible with traditional spreadsheet data, allowing you to easily generate letters, labels, and envelopes without complex configurations.

  1. 1. Open WPS Writer: Launch WPS Writer and navigate to the Mailings tab on the top ribbon menu, then click on 'Mail Merge'.
  2. 2. Connect Data Source: Click 'Open Data Source' and browse your computer to select the spreadsheet containing your contact records.
  3. 3. Filter Blank Records: Click 'Mail Merge Recipients' to open the recipient list, where you can easily uncheck blank rows or apply a filter condition to exclude them.
  4. 4. Insert and Merge: Use 'Insert Merge Field' to place your data placeholders, preview the results, and click 'Merge to New Document' to generate your final pages.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mailings tab makes filtering blank records and inserting merge fields effortless.Lightweight software with a familiar interface for a quick and seamless transition.Free to download and use for your essential document processing needs.
microsoft office alternative - wps office

Frequently Asked Questions

Why are completely empty Excel rows showing up in my mail merge?

The word processor sometimes reads empty rows at the bottom of your spreadsheet as valid data entries due to leftover formatting. You can prevent this by opening the 'Edit Recipient List' dialog and unchecking the completely blank rows, or by deleting unused rows in your spreadsheet.

Can I filter by multiple conditions in a mail merge?

Yes. In the Filter dialog under Edit Recipient List, you can use the 'And/Or' operators to establish multiple rules. For example, you can filter records where the Email 'Is Blank' AND the Country 'Equal to' USA.

Does using the 'Is Blank' filter delete the records from my original spreadsheet?

No. Filtering records during a mail merge only excludes them from the generated output (labels or letters). Your original spreadsheet data remains completely unaffected and intact.

How do I skip records if they contain specific text instead of being blank?

Open the Edit Recipient List dialog, click Filter, choose the relevant column, and set the Comparison drop-down to 'Does Not Equal' or 'Does Not Contain'. Then, type the specific text you wish to exclude in the Compare to field.