How can I print Name and Address fields on Envelope for a single record.
And specify envelope size. I tried using the Label Wizard but I want only
the select record not all records. Any idea how to do this?
Thanks
Printing on an envelope is just like printing any other 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 controls 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.
As far as selecting the various envelope size, for me the easiest way
is to simply have different reports, one for #10 envelope, one for
some other size envelope, etc.
Then you can select the different envelope size, perhaps using an
Option Group, and in code open the report associated with that size.
If Me.OptionName = 1 then
DoCmd.OpenReport "EnvelopeSizeA"
Else
DoCmd.OpenReport "EnvelopeSize B"
End If
