Microsoft KB Archive/68493

Word: Selectively Merging Mailing Labels

PSS ID Number: Q68493 Article last modified on 11-02-1994

3.00 4.00 5.00 5.50 6.00

MS-DOS

= SUMMARY =

Because merging mailing labels usually requires the use of the NEXT statement, it is difficult to selectively merge labels using the SKIP statement. Combining SKIP and NEXT in the same merge results in some labels being inadvertently skipped during the merge process.

One way to overcome this problem is to perform the merge in two steps so that SKIP and NEXT statements are not combined in one print merge.

Use the original data document with a main document that contains the SKIP instructions to create a new data document containing only the desired data items (print merge to a file or new document). Add a header line to the new data document and perform the final print merge using the new data document.

Example
A data document has the following fields:

first,last,address,income

In order to print only those labels that have an “income” greater than or equal to 200, create a main document that reads

< ><<><>< >, < >, < , < > <> where “<<” is CTRL+[ and “>>” is CTRL+].

All of the above information should be placed on line 1 of the main document (allow the text to wrap at the end of the line).

With the above main document, perform a print merge to a “new document” (Word 5.50) or to a file (Word 5.00) instead of directly to the printer. The resulting document will include only those records with an income greater than or equal to 200. Add a header line to the top of the document and perform the mailing label merge using this document for the data document.

KBCategory: kbother KBSubcategory: kbmerge Additional reference words: ============================================================================= Copyright Microsoft Corporation 1994.