When compiling customer statements, donor receipts, event passes, or promotional mailers in Microsoft Word using Mail Merge, underlying data sources frequently contain records that should not receive a document. For example, an accounting spreadsheet may include accounts with zero balances, inactive customer statuses, or missing postal addresses. If you run a mail merge without filtering, Word prints dozens or hundreds of unnecessary blank or meaningless letters, wasting paper, envelope costs, and postage. To filter records conditionally during the merge process without altering the original master spreadsheet, Word provides the built-in SKIPIF field code.
Understanding the SKIPIF Field Code
The SKIPIF field code evaluates a logical condition against fields in the current recipient record:
- Conditional Suppression: If the logical statement evaluates to
True, Word cancels merging for that individual record immediately, advances to the next record in the database, and begins a fresh document. - Non-Printing Control Code:
SKIPIFdoes not output visible text onto the printed document; it operates purely as an execution flow control instruction. - Continuous Sequential Renumbering: When combined with sequence counters like
{ MERGESEQ }, skipped records do not create gaps in output serial numbers.
Syntax and Logical Operators
The standard syntax for the SKIPIF field code is:
{ SKIPIF Expression1 Operator Expression2 }
Common comparison operators include:
=: Equal to<>: Not equal to>: Greater than>=: Greater than or equal to<: Less than<=: Less than or equal to
Inserting the SKIPIF Field via the Ribbon Interface
To insert a conditional skip instruction using Word\u2019s guided interface:
- Open your Mail Merge document and ensure your data source is connected.
- Place your cursor at the very top of your document (before any headings or text).
- On the Mailings tab, in the Write & Insert Fields group, click Rules.
- In the dropdown menu, select Skip Record If….
- In the dialogue box, configure your condition:
- Field name: Select the database column to evaluate (e.g.,
AccountBalance). - Comparison: Choose the operator (e.g., Less than or equal).
- Compare to: Enter the threshold value (e.g.,
0).
- Field name: Select the database column to evaluate (e.g.,
- Click OK. Word inserts the conditional rule.
Inserting and Customizing SKIPIF Using Keyboard Shortcuts
Advanced template creators can insert and customize field codes directly using keyboard shortcuts:
- Place your cursor at the very beginning of the document body.
- Press Ctrl + F9 (or Cmd + F9 on macOS) to create outer field code braces:
{ } - Inside the braces, type
SKIPIFfollowed by your merge field:
Note: The inner{ SKIPIF { MERGEFIELD AccountBalance } <= 0 }{ MERGEFIELD }must also be created by pressing Ctrl + F9; you cannot type curly braces manually. - Press F9 to evaluate and register the field code.
To view the underlying code at any time, press Alt + F9.
Practical Examples of SKIPIF Filtering
Here are common business scenarios implemented with SKIPIF:
- Suppressing Inactive Customers:
{ SKIPIF { MERGEFIELD Status } = "Inactive" } - Suppressing Records with Missing Postal Codes:
{ SKIPIF { MERGEFIELD PostalCode } = "" } - Excluding Specific Geographic Regions:
{ SKIPIF { MERGEFIELD Country } <> "United Kingdom" }
Testing and Previewing Merged Records
To verify that records are correctly skipped prior to producing the final batch:
- On the Mailings tab, click Preview Results.
- Advance through records using the navigation arrows.
- Notice that records matching your skip condition do not display; Word jumps seamlessly to the next eligible record.
- Click Finish & Merge > Edit Individual Documents. The resulting document contains only the filtered, relevant customer letters without blank pages or zero-value statements.