Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Getting Rid of Blank Labels in a Filtered Merge.

Getting Rid of Blank Labels in a Filtered Merge

by Allen Wyatt
(last updated August 5, 2017)

Peggy experienced a problem printing merged labels from a filtered database. It seems that the labels she wanted were printing out, but the printing was also kicking out a blank label for every record filtered out of the merge.

Quite honestly, this problem should not occur in Word. If you use the standard Mail Merge Wizard, it sets up your labels so that you don't get blanks; you only get the labels you want. If you are not getting that, then the most likely culprit is the actual main document created in Word. You can try this:

  1. Open the main document—the one that you use to merge with your data.
  2. Press Alt+F9. This should display all the field codes in the document.

Merging is accomplished through the use of field codes. If the codes are incorrect, the merging is not done properly. The purpose of the Mail Merge Wizard is to get enough information from you that Word can set up the field codes properly.

When printing labels, the field codes specify where the individual bits of information go that make up each label. Your document should consist of a table, with each cell of the table responsible for a single label. What you are looking for right now is the composition of the first label, in the upper-left corner of your table. This is your base label. Every other cell in the table should look the same as this base label, with the exception of a {NEXT} field at the beginning of the label. This field, when encountered during a merge, causes Word to proceed to the next record in the source data.

If, after examining the field codes for your labels, you discover that they are not the same (with the exception of the {NEXT} field), then you need to start over and use the Mail Merge Wizard to again create your main document.

Another thing to check is the actual filtering that you are doing. If you are filtering your data records based on a non-printing field, it is possible that the filter is not functioning according to your expectations. In fact, it might not be filtering at all, and you can't tell because you never print the field on which you are filtering. Check to make sure that the filter is set up properly.

If you still run into problems, then you could check your source data. For instance, if you are using an Access database as your data source, you could define a query in Access that defines the labels you want to print. Use this query as the data source in Word for your mail merge. Thus, Word is not doing the filtering, but Access is handing Word data that has already been filtered.

Finally, you can get rid of records that have blank fields by using the {NEXTIF} field in your labels. This field code checks the contents of a specific field against a criterion that you set. If the criterion is met, then the merge proceeds to the next record in the data source. Why would you use such a field? It is very helpful if your data source contains a lot of records that are only partial—for instance, you may have data records that record a first name but not a last name. Consider the following field code, which could be placed at the beginning of a label:

{ NEXTIF { MERGEFIELD LastName }= "" }

This checks the LastName merge field, and if it is empty, the record is skipped and Word proceeds to the next record.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1790) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Getting Rid of Blank Labels in a Filtered Merge.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Professional Looking Fractions

Professional typesetting has, in many ways, spoiled us. One way this is evident is in the preference we show for making ...

Discover More

Inserting and Deleting Rows in a Protected Worksheet

You've protected and saved your worksheet with explicit instructions that you be allowed to insert and delete rows. But ...

Discover More

AutoFill Won't Work as Expected

AutoFill is a great tool for filling cells with data. What do you do when it doesn't work like you expect, however? ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (menu)

Conditional Processing During a Mail Merge

The Mail Merge capabilities can appear limited at first glance. One thing that is often overlooked (and which makes the ...

Discover More

Automatically Determining a Due Date

When you are doing a mail merge in Word, you may need to calculate a date sometime in the future. Word doesn't include an ...

Discover More

Mail Merge and Data Source Documents become Unattached

When you create a mail merge document, you attach it to a data source that is the basis for the information to be merged ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is one more than 2?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.