Microsoft KB Archive/88374

= Microsoft Knowledge Base =

WD: WinWord: Print Merge Produces a Full Page of Labels
Last reviewed: August 11, 1997

Article ID: Q88374

The information in this article applies to:


 * Microsoft Word for Windows, versions 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c
 * Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
 * Microsoft Word for Windows 95, versions 7.0, 7.0a
 * Microsoft Word 97 for Windows
 * Microsoft Word for the Macintosh, versions 6.0, 6.0.1

SUMMARY
If you select a range of records when you are performing a print merge to create mailing labels, Microsoft Word merges a full page of labels. The first record on the page is the first record of the selected range, but Word continues merging labels until the page is filled, rather than stopping with the last record of the selected merge range. The print merge operation creates full pages only when you create mailing labels, even if the selected range does not fill the entire page.

For example, if your mailing label main document contains 30 labels and you choose to merge records 1 through 20, Word merges records 1 through 30 to create a full page of labels. Similarly, if you choose to merge records 1 through 40, Word merges records 1 through 60 to create two full pages of labels.

STATUS
Microsoft has confirmed this to be a problem in the versions of Word listed previously. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
To work around this problem, use one of the following methods:

Workaround 1
  In place of a merge field, insert the following IF field in your print merge main document: {IF {MERGEREC} <= {MAXRECORDS} {MERGEFIELD FIELD1}}   Insert the following field at the start of your print merge main document: {SET MAXRECORDS N} where &quot;N&quot; is the number of records to merge. For example, if you want to print records 1 through 20, N=20.  From the File menu, choose Print Merge. Choose the Merge button. In the Print Records box, type the range of records and choose the OK button.

Workaround 2

 * 1) In the print merge data document, add a field named &quot;Rec_Num&quot;.

Word 6.0: For information on adding a new field to a data

file, refer to of the &quot;Microsoft Word for Windows User's Guide,&quot; page 690. Word 2.0: For information on adding a new field to a data

file, refer to of the &quot;Microsoft Word for Windows User's Guide,&quot; page 618. Use the Rec_Num field to number the records in your data document.

Activate the mailing label main document.

From the File menu, choose Print Merge. Choose the Merge button.

Choose the Record Selection button.

In the Field Name box, select Rec_Num. In the Is box, select Less than or Equal to. In the Compared To box, type &quot;5&quot; (without the quotation marks). Choose the Add Rule button.

In the Field Name box, select Rec_Num. In the Is box, select Greater than or Equal to. In the Compared To box, type &quot;2&quot; (without the quotation marks). Choose the Add Rule button.

Choose the OK button.

Complete the print merge.