How to Print Envelopes From an Access Query
- 1). Open a blank document in Microsoft Word.
- 2). Select the "Mailings" tab and go to the "Start Mail Merge" group. Click on "Start Mail Merge" arrow and pick the "Step by Step Mail Merge Wizard..."
- 3). Choose "Envelopes" from document type in the "Mail Merge" pane and click on "Next: Starting document."
- 4). Select "Use the current document" and click on the "Envelope options..." link to pick your envelope size. Click on "OK" to close the "Envelope Options" dialog box, and then on "Next: Select recipients."
- 5). Leave "Use an existing list" selected under "Select recipients" and click on "Browse" to navigate to your Access database. Double-click on the Access database you need. In the "Select Table" dialog box, select the Access query from the list. (The Access type for your query should say, "VIEW.") Click on "OK."
- 6). Select "Next: Arrange your envelope" and place your cursor in the middle of the blank envelope where your addresses will be placed.
- 7). Select "More items.." and double-click on the fields you want to add. (Word will insert placeholders for each field name.) Click on "Close."
- 8). Go to the envelope on your page and arrange field the way you'd like it to appear. Select "Next: Preview your envelopes" when you are done.
- 9). Select "Next: Complete the merge" and click on "Print." Choose to print all the records, only the current record, or a particular range of records, then press "OK." The "Print" dialog box will open.
- 10
Load your envelopes into the printer and press "OK."
