How to print envelopes directly from Access.
|
Q:Jim Coxon writes: “What I need to do is to print envelopes directly from Access. i.e. Customer rings up for tickets, agent enters details into Access using a form, form is printed, agent puts tickets into envelope. If we could print the envelope directly then she could put the tickets and other info directly into the envelope and job is finished. Can you help please?” A:If your printer can handle envelopes (and I assume it can, otherwise this entire enterprise is doomed), then all you have to do is create an Access report using the appropriate envelope size as the paper size (probably COM 10), with a query or SQL statement for its record source using a value from the form as a criterion (the key field is best). Put the name and address fields on the envelope report. Then put a command button on the form to print the report, and it will print the data to the envelope. I presume you are already doing this with the form, so the process is similar, just using a different paper size. |
