How to Skip Blank or Nonblank Records in Word Mail Merge
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.

- 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.
Ensure your data source spreadsheet is saved, closed, and formatted with clear column headers (like 'Email' or 'Address') before initiating the mail merge.
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.
Navigate to the Mailings tab on the top ribbon and click on 'Edit Recipient List' after linking your data source.
In the Mail Merge Recipients dialog box, click on the 'Filter...' link located in the Refine recipient list section.
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.

Prepare a Separate Worksheet for Target Records
A simple workaround is to filter and isolate the necessary records in your spreadsheet software before connecting it to the mail merge.
Automate the Filter with a VBA Macro
For advanced users, a VBA macro using SQL queries can permanently enforce this filtering rule when generating the merge.
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. Open WPS Writer: Launch WPS Writer and navigate to the Mailings tab on the top ribbon menu, then click on 'Mail Merge'.
- 2. Connect Data Source: Click 'Open Data Source' and browse your computer to select the spreadsheet containing your contact records.
- 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. 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.

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.




