Microsoft KB Archive/279725

= ACC2000: How to Use the Label Wizard to Print Mailing Labels from a Table or a Query =

Article ID: 279725

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q279725



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
You can print mailing labels from a table or a query by creating a report using the Label Wizard.



MORE INFORMATION
To use the Label Wizard to create a report, follow these steps:  In the Database window, click Reports under Objects, and then click New. In the New Report dialog box, click Label Wizard. In the Choose the table or query where the object's data comes from list, select the table or the query that you want to create labels from, and then click OK. On the first page of the Label Wizard, select the values that you want for Product number, Unit of Measure, Label Type, and Filter by manufacturer, and then click Next.

NOTE: If you cannot find your exact labels, or if the margins are not correct for your labels, you can click Customize, and then design your own labels. On the next page of the Label Wizard, select the values that you want under Text appearance, and then click Next. On the next page of the Label Wizard, set up your label layout. You can use your keyboard to create new lines, spaces, commas, and so on. A common layout for addresses is as follows. You can have up to four lines in the layout. When you are finished, click Next.

{Name}

{Address}

{City}, {State} {Zip}

</li> On the next page of the Label Wizard, select a field to sort by, and then click Next.</li> On the last page of the Label Wizard, type a name for your report, and then click Finish.</li></ol>

You can now click Print on the File menu to print the report to your labels. If the resulting label report does not look the way you want it to, you can delete the report, and then run the Label Wizard again.

Keywords: kbinfo KB279725

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.