How to Print Envelopes From an Access Report

Written by lisa m. mcmahon
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Print Envelopes From an Access Report
Use your Access database to save time addressing envelopes. (Comstock Images/Comstock/Getty Images)

If you have addresses stored in a Microsoft Access database, you can automate the process of addressing envelopes. Access provides a Label Wizard to step you through the process of creating labels for your customer, Christmas card, or other list. Using a custom label, you can even print directly to envelopes rather than sheets of labels.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Click "Start" > "All Programs" > "Microsoft Office" > "Microsoft Access 2010." Click "File" > "Open," locate your database containing the Addresses and click "Open."

  2. 2

    Click "Labels" on the Create tab on the Microsoft Access 2010 ribbon. Select "Sheet Feed" for Label Type. Click "Customize" in the Label Wizard.

  3. 3

    Click "New." Enter a name for your envelope, for example "#10 Envelope." Enter the dimensions of your envelope, including the minimum margins for your printer. For example, enter 0.30", 0.30" and 0.30" for the left, top and right margins and 3.83" and 8.9" for the width and length of the top left label. Click "OK," then "Close."

  4. 4

    Click "Next." Select your font size, colour and weight options, for example "Arial," "12" and "normal." Click "Next."

  5. 5

    Select from the available fields on the left and click ">." Access will add the correct formatting for each field. Add spaces and punctuation where applicable. For example:

    {First Name} {Last Name}

    {Company}

    {Address}

    {City}, {State/Province} {ZIP/Postal Code}

    {Country/Region}

  6. 6

    Click "Next" to add an optional sort, for example by postcode or company. You can select more than one sort option. Click "Next."

  7. 7

    Enter a name for this report, for example, "Customer Envelopes." Select "Modify Label Design" and click "Finish."

  8. 8

    Select "Page Setup" on the ribbon under the Page Setup tab of the Report Design Tools group. Select "Com-10" for Page Size on the Page tab. Click "OK." Drag the page size to the right to match the envelope size, if necessary.

  9. 9

    Select all the report fields by clicking the first one and then holding down the Control key and clicking the others. Drag the fields to the correct spot on the envelope. Select "File" > "Print" > "Print Preview." If everything looks good, click "Print."

Tips and warnings

  • An easier way to print addresses on envelopes, according to Microsoft, is to export the addresses to Word and use Mail Merge.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.