Microsoft KB Archive/93347

= Printing Multiple Copies of an Address Label =

Article ID: 93347

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Windows 98 Standard Edition

-



This article was previously published under Q93347



2.00 WINDOWS kbprint



SUMMARY
There are two methods that may be used to print a page of identical mailing labels in Microsoft Works for Windows. For example, either of the following might be used to print multiple return-address labels.


 * Enter the address once into the word processing document, then insert the field placeholder from a database containing a field with nothing but spaces, and use the Print Labels command to print as usual.
 * Using the Fill Down command in the database, create a database with multiple copies of the same record before creating and printing the mailing labels as usual.

For more information about creating mailing labels, see pages 73-74 of the &quot;Microsoft Works for Windows User's Guide.&quot;



Method 1: Entering One Address and Merging with a Blank Field
 Determine the number of labels to be printed per page. For instance, a page with 3 columns and 10 rows of labels would have 30 labels. From the File menu in Works for Windows, choose Create New File and select Database. From the View menu, choose List to switch to List View. In the first field (top left), enter a quotation mark followed by a space, as in the following:

'&quot; ' (without the single quotation marks)

After pressing ENTER, the name Field1 appears at the top of this column. Highlight the first n rows in the database, where n represents the number of labels to be printed per page. From the Edit menu, choose Fill Down.</li> From the File menu, choose Create New File and choose Word Processor in the following dialog box.</li> Type the address you wish to print on each label normally, as if you were typing directly on the label itself.</li> After typing the address, position the insertion point immediately below the address. From the Insert menu, choose Database Field.</li> Select the name of the database, highlight the name of the field ('field1'), and then choose OK or press ENTER. Your word processing document should now look something like this:

Microsoft Corporation

One Microsoft Way

Redmond, WA 98052-6399

<<Field1>>

The purpose of adding the blank field placeholder is to enable the Print Labels command to be used, so that multiple copies of the address are printed.</li> From the File menu in the Word Processor, choose Print Labels and follow the procedure described on page 74 of the &quot;Microsoft Works for Windows User's Guide.&quot;</li></ol>

Method 2: Using Multiple Copies of the Same Record
The normal procedure for printing mailing labels is described in full on pages 73-74 of the &quot;Microsoft Works for Windows User's Guide.&quot; With a minor modification, you can print a sheet of identical labels.


 * 1) Create a label database as described on pages 222-233 of the &quot;Microsoft Works for Windows User's Guide&quot; or open an existing one with the fields you want to print.
 * 2) Determine the number of labels to be printed per page. For instance, a sheet with 3 columns and 10 rows of labels would have 30 labels.
 * 3) In the List View of the database, enter or find the address to be printed, and hide all other records.
 * 4) With the address to be printed as the only one visible, select the first n records, where n represents the number of labels per page.
 * 5) From the Edit menu, choose Fill Down.
 * 6) Now switch to an existing label document, or create one as described on page 73 of the &quot;Microsoft Works for Windows User's Guide.&quot;
 * 7) From the File menu in the Word Processor module, choose Print Labels and follow the procedure described on page 74 of the &quot;Microsoft Works for Windows User's Guide.&quot;

Because the address to be repeated was repeated in the database, Works prints the same address on a full sheet of labels. To return the database to its original form (if an existing database was used), close the database without saving changes.

<div class="references_section">