In Access: I would like to know how to print just one envelope from the list
of names and addresses in the database. Do I do a query and a report?
Printing an address on an envelope is no different than printing any
other kind of report. Create a report to print on an envelope.
You haven't given much away as far as what your requirements are, so
as far as selecting just the one address to print, perhaps adding a
Check Box field to your table, and form, and using that field to
filter the records will work. Code a command button click event:
DoCmd.OpenReport "AddressReport", acViewPreview, , "[CheckBoxField] =
-1"