Envelopes

message from Antonio on 2 Jun 2004

I have a table containing various contact addresses. This
table is connected to various forms, used for various
reasons. Is it possible to make print an envelope based
on the address that is currently displayed on a form?
Ideally, the user would find the address they needed,
press a button, and the printer next to their desk (which
has the manual feed tray loaded with blank envelopes)
spits out an envelope with the address they are looking
at. Any ideas?
TIA

Albert D. Kallal replied to Antonio on 2 Jun 2004

I done this quite a few times.

All I did was create a report in landscape mode, and then put the address in
the middle (or upper top, or bottom, depending on how the printer feeds
(most laser are center..while HP Ink Jets are bottom, or top centered.

You then place a button on the form that will print this ONE record to the
report.

The code you use is:

me.refresh
docmd.OpenReprot "MyEvenlope",,,"id = " & me.ID

The "id" field above needs to be replaced with whatever field you used for a
key id (the above is the common autonumber ID field...so use whatever you
used).

You will need to "practice" with a bunch of blank paper to save envelops.
Just "imagine" the position of the envelope in regards to the full sheet of
paper. (you can even hold up the paper to a light source right after you
print, and then place the envelope behind it to see how well they line up.
Once you get REAL close..then you can start wasting a few "real" envelops to
get it just right....

Antonio replied to Albert D. Kallal on 3 Jun 2004

Thank you very much Albert, it worked like a charm.

then put the address in
the printer feeds
top centered.
ONE record to the
field you used for a
use whatever you
to save envelops.
to the full sheet of
right after you
well they line up.
few "real" envelops to

Archived message: Envelopes (Microsoft Access Database)