Print One Envelope

[Thomas Kroljic]

All,
What is the best approach to printing one Envelope from an Access
application? Currently, my application (Acc 2000) allows the user to print a
form letter for a specific customer using vba code to move data to a Word
document using "bookmarks. This works fine. (I had to do a little research
to fine the appropriate code.)
Now I would like to print out an envelope. It seems I have two choices, 1) I
can use the Word approach, which I'm not that familar with or 2) I can
create a simple Access report and define the paper size to, in my case, #10
Envelope. What is the preferred method? I'm using a HP 1300 printer.

Should I stick with the Word approach? if so, how do I move data from the
access data record to Word for the envelope?

It seems creating an Access report to print an envelope would be the
simplest way, but I would like to get some feedback before I go this route.

If this isn't the correct forum to post this message, please let me know
which one is.

Thank you,
Thomas J. Kroljic

 

[fredg]

All,
What is the best approach to printing one Envelope from an Access
application? Currently, my application (Acc 2000) allows the user to print a
form letter for a specific customer using vba code to move data to a Word
document using "bookmarks. This works fine. (I had to do a little research
to fine the appropriate code.)
Now I would like to print out an envelope. It seems I have two choices, 1) I
can use the Word approach, which I'm not that familar with or 2) I can
create a simple Access report and define the paper size to, in my case, #10
Envelope. What is the preferred method? I'm using a HP 1300 printer.

Should I stick with the Word approach? if so, how do I move data from the
access data record to Word for the envelope?

It seems creating an Access report to print an envelope would be the
simplest way, but I would like to get some feedback before I go this route.

If this isn't the correct forum to post this message, please let me know
which one is.

Thank you,
Thomas J. Kroljic

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 to #10 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.

 

[Thomas Kroljic]

Fred,
Works like a charm. Thank you very much for the response and code.
Printing an envelope as a report in Access is a no-brainer. Thanks again.

Thomas J. Kroljic