Word Mail Merge Skips Records With Blank Fields: Fix

When you run a mail merge in Word, some records may be skipped entirely if they contain blank fields. This happens because Word treats an empty merge field as a null value and skips the entire record to avoid printing incomplete data. The default behavior is controlled by the Omit Empty Fields setting in the mail merge connection. This article explains why Word skips records with blank fields and provides a step-by-step fix to include those records.

Why Word Skips Records With Blank Fields During Mail Merge

Word connects to a data source such as an Excel worksheet, a CSV file, or an Outlook contacts list. When a field in a record is blank, Word interprets that as a null value. By default, the mail merge engine filters out records that contain null fields to avoid printing empty placeholders. This behavior is intentional to prevent incomplete output, but it can cause entire records to be omitted if even one required field is empty.

The root cause is usually one of the following:

• The data source has blank cells in the column used for the merge field.
• A filter or query rule in the mail merge recipient list excludes records with empty fields.
• The Omit Empty Fields option is enabled in the mail merge connection settings.

Word does not display a warning when it skips a record. You may notice the total count of merged documents is lower than the number of records in your data source. The fix involves adjusting the recipient list settings or modifying the data source.

Steps to Fix Word Mail Merge Skipping Records With Blank Fields

Follow these steps in order. Each method resolves a different cause of the problem.

Method 1: Clear All Filters in the Mail Merge Recipient List

1. Open the Mail Merge Recipient list
   In Word, go to Mailings > Select Recipients > Use an Existing List (or the data source you already connected). Click Edit Recipient List on the ribbon.
2. Check for active filters
   In the Mail Merge Recipients dialog, look at the column headers. If any column header shows a downward arrow icon, a filter is applied. Click the arrow and select Clear Filter from the dropdown menu.
3. Remove all filter rules
   Click the Filter link at the top of the dialog. In the Filter and Sort dialog, go to the Filter Records tab. Delete any criteria listed under Field, Comparison, and Compare to. Click OK.
4. Verify all records appear
   Scroll through the recipient list. Records that were hidden now appear. Check the checkboxes next to the records you want to include. Click OK to save changes.

Method 2: Manually Re-Select Skipped Records

1. Open the Mail Merge Recipient list
   Go to Mailings > Edit Recipient List.
2. Identify unchecked records
   Look for records with an unchecked checkbox. These are the records that Word skipped.
3. Check the skipped records
   Click the checkbox next to each skipped record to select it. If many records are unchecked, click the Select All button at the top, then uncheck only the records you want to exclude.
4. Run the merge again
   Click OK and then Finish & Merge. The skipped records should now appear in the output.

Method 3: Fill Blank Cells in the Data Source

1. Open the data source file
   If your data source is an Excel workbook, open it in Excel. If it is a CSV file, open it in Notepad or Excel.
2. Locate blank cells in the merge field column
   Identify the column that corresponds to the merge field causing the skip. For example, if the merge field is AddressLine2 and many cells are blank, those records will be skipped.
3. Fill blank cells with a space or placeholder
   Type a single space character in each blank cell. Alternatively, type a dash or the word “N/A.” Do not leave any cell empty. Save the file.
4. Reconnect the data source in Word
   Go to Mailings > Select Recipients > Use an Existing List. Browse to the updated file. Word will reload the data, and blank fields now contain a space. Run the merge again.

Method 4: Disable the Omit Empty Fields Setting (Advanced)

1. Open the mail merge main document
   Ensure your main document with merge fields is open.
2. Press Alt+F11 to open the VBA editor
   This method requires using a macro. Go to Insert > Module in the VBA editor.
3. Paste the following macro code
   Sub DisableOmitEmptyFields()
Dim mmMain As MailMerge
Set mmMain = ActiveDocument.MailMerge
mmMain.OmitEmptyFields = False
End Sub
4. Run the macro
   Press F5 while the cursor is inside the macro. Close the VBA editor. Save the document. Run the mail merge again.

If Word Still Has Issues After the Main Fix

Word skips records only when printing to a new document

If you choose Edit Individual Documents, Word may still skip records. Instead, try Finish & Merge > Print Documents or Send E-mail Messages. This bypasses the preview logic that sometimes filters records.

Data source contains hidden rows or columns

In Excel, hidden rows or columns are still included in a mail merge. But if you have applied a filter in Excel, Word only sees the visible rows. In Excel, go to Data > Filter and clear any active filter. Save the file and reconnect in Word.

Merge field name does not match the column header exactly

If the merge field name in Word has a trailing space or differs in case from the column header, Word may treat the field as blank. Check the field name by clicking the merge field in the document and pressing Shift+F9 to see the field code. The field name must match the column header exactly.

Mail Merge Filter vs Data Source Modification: Behavior Comparison

Item	Clear Filters in Recipient List	Fill Blank Cells in Data Source
Time to apply	Less than 1 minute	5 to 15 minutes depending on data size
Permanence	Resets after closing the document	Permanent change to data source
Affects all merge fields	Yes, all filters removed	Only the column you edit
Requires data source access	No, works within Word	Yes, you must edit the source file
Risk of data corruption	None	Low, if you only add spaces

Use the clear filters method first because it is fastest and non-destructive. If the problem persists, fill blank cells in the data source.

You can now run a mail merge that includes every record even when some fields are blank. Start by clearing all filters in the Mail Merge Recipient list. If records are still skipped, open your Excel or CSV data source and add a space character to each blank cell in the merge field column. For advanced control, use the VBA macro to disable the Omit Empty Fields setting. This ensures your merged output contains all intended records without manual re-selection each time.