How to Print Envelopes From an Access Report

1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Access 2010.' Click 'File' > 'Open,' locate your database containing the Addresses and click 'Open.'
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. 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. Click 'Next.' Select your font size, color and weight options, for example 'Arial,' '12' and 'normal.' Click 'Next.'
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. Click 'Next' to add an optional sort, for example by postal code or company. You can select more than one sort option. Click 'Next.'
7. Enter a name for this report, for example, 'Customer Envelopes.' Select 'Modify Label Design' and click 'Finish.'
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. 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.'