Envelopes

[Antonio]

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]

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]

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