Printing on Envelopes in Access

[Paul]

I would like to know if there is an easy way to print to
envelopes in access. I can create labels, but I want to
print directly on an envelope.

Thanks.

 

[Fredg]

Paul,
Printing on an envelope is just another report.

First you must determine if your report is going to print in Portrait or
Landscape mode.
If the envelope feeds into the printer narrow side first, it will be in
Landscape.
If flap side first, Portrait.

The below instructions are for Landscape.

Make a new report.
Place the Address labels at the left margin.
Size the width of the report just a bit wider than the labels.

click File + PageSetUp + Page
since the envelope feeds in narrow side first,
set the Page Orientation to Landscape.
Then click on the Margins tab.
Set the Left and Top margins to print the address at the proper place on
the envelope.
To print on a #10 business envelope, for example, I set the Top margin to
2.75" and the Left margin to 3" in Landscape.

Print a sample.
Readjust margin settings as needed

For Portrait mode, follow the above instructions, but, of course, change the
Page SetUp mode to Portrait, and adjust the margin settings accordingly.