Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Icon: Flag: (c) Microsoft
Get up to speed
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Print mailing labels
 
  1. If the labels do not exist, create them.

    ShowHow?

    Before creating labels that print on a dot-matrix or tractor-feed printer, set the default printer and paper size.

    1. In the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click Reports Button image.

    2. Click the New button on the Database window toolbar.
    3. In the New Report dialog box, click Label Wizard.
    4. Click the table or query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.) that contains the data for the labels, and then click OK.
    5. Follow the instructions in the wizard.

      If the resulting label report doesn't look the way you want, you can customize it in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).

  2. Click Print on the toolbar.

    If the printed labels don't look the way you want, customize the page settings in the Page Setup dialog box.

advertisement