Printing Envelopes from Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2002 XP.

I need to set up a command button which allows me to automatically print
envelopes from a form.

I can achieve this manually by saving the filter as a query and then going
through the mail merge wizard, but I need a button that will automate the
process.

Does anyone have anything that can show me how to achieve this in idiot-speak?
 
Simon,
I print single envelopes right from my Personal Database. I just created
a report that prints the Name and Address of the record I'm on when I press
the Print Envelope button (cmdPrintEnvelope)
I placed the cmdPrintEnvelope button on my form, and used the OnClick
event of the button to run the code that opens the report.
The query behind the report uses the Key field (IDNo) value from the open
form to filter out all records from my address database but the one
displayed.
In the IDNo field of my query, I use this criteria...
=[Forms]![frmAddresses].[IdNo]
I adjusted the resulting text fields (name, address, city, etc..) on the
report (high, low, left, right, horizontal, or landscape) until I got the
results I needed for my printer envelope feed.
hth
Al Camp
 
Back
Top