Can Access print envelopes

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have access set up to print invoices which I then post to customers. I
then have to startup Word to print envelopes. Is it possible to setup Access
to print an envelope after I print the invoice. I have a separate printer
that I use to print envelopes.

Any help appreciated.
John
 
I have access set up to print invoices which I then post to customers. I
then have to startup Word to print envelopes. Is it possible to setup Access
to print an envelope after I print the invoice. I have a separate printer
that I use to print envelopes.

Any help appreciated.
John

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 + Page SetUp + Page
Select the envelope size in the paper size box.
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.
 
Thanks for that. I'll give it a go.

John

fredg said:
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 + Page SetUp + Page
Select the envelope size in the paper size box.
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.
 
Back
Top