Envelope/Label

  • Thread starter Thread starter Tim Eagle
  • Start date Start date
T

Tim Eagle

Does anyone know of the dimensions to set up for a label so I can print a
query on an envelope? I'm getting tired of guessing. Thanks. I have the
query down, I just need to figure out how to print an envelope from my
database. Thanks in advance.

Tim Eagle
(e-mail address removed)
 
Does anyone know of the dimensions to set up for a label so I can print a
query on an envelope? I'm getting tired of guessing. Thanks. I have the
query down, I just need to figure out how to print an envelope from my
database. Thanks in advance.

Tim Eagle
(e-mail address removed)
Click to expand...

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
Set the Paper Size property to the size of the envelope.
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.
 
Does anyone know of the dimensions to set up for a label so I can print a
query on an envelope? I'm getting tired of guessing. Thanks. I have the
query down, I just need to figure out how to print an envelope from my
database. Thanks in advance.

Tim Eagle
(e-mail address removed)
Click to expand...

Don't use a Label; use a Report. Get a ruler and measure your
envelope; or, a standard No. 10 business envelope is 4.125" high by
9.5" wide. Size the Report to match this; set the margins to 0 (or as
small as possible, subtracting the margin from that dimension of the
envelope); put the textboxes neatly on the report wherever you want
them.

Yes, this should be a builtin template, but once you've done one you
can copy the Report into any database.

John W. Vinson[MVP]
 
Back
Top