ENVELOPES IN ACCESS

[J. PRINTKE]

i WOULD LIKE TO BRING UP A RECORD IN ACCESS AND PRESS A
BUTTON AND PRINT A # 10 ENVELOPE, WITH NO RETURN ADDRESS.
I HAVE IN MY FIELDS, FIRST NAME, LAST NAME, STREET ADDRESS
AND CITY,STATE ZIP. I WOULD ALSO LIKE TO FILL IN FIELDS IN
A FORM FROM THE DATA IN MY DATABASE.HELPPPPPPPP

 

[Albert D. Kallal]

You can build a report that looks like a envelope.

Just make the report landscape, and place the fields in the middle. You will
have to test, and using paper in place of envelopes will save envelopes
during testing.

To print ONLY the current record you are looking at, you use:

docmd.openreport "myenvelope",,,"id = " & me!id

The above assumes you have a key field of id