Solved

Envelope printing from MS-Access.

Posted on 2001-09-12
3
706 Views
Last Modified: 2006-11-17
I have a database. So, sometimes user need to print A4 letter with some fields inside (no problem).

At certain time, they want to print using envelope to print the addresses. tHEY don't want to use the labels but instead wanting to use the envelope.

How do to envelope printing. The measurement is 4.5" * 9.5". Am I suppose to use the label wizard to do this also?. And how to change the cm or mm to inch measurement?

Please tell me how to :
a. print using envelope at certain time from MS-Access. Most of the time they will be using A4 size paper using the laserjet printer.
b. how to print using envelope (4.5" * 9.5" size). Do i have to add the same printer another time and custom size the paper size.

Thank you experts..
hope to hear from you soon.

pandav
 
0
Comment
Question by:pandav
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 50 total points
ID: 6479509
pandav,

 It's rather simple: just treat the envlope as a "regular report".  Don't need to worry about paper size or anything.  Just start off with a blank report, locate the return/address info in the upper left corner.  Then set portrait or landscape as need be to send the envelope through the way you need to.

That's it!
Jim.
0
 
LVL 57
ID: 6479511
Note for the "report", you may want to set the printer to "manual feed" as well.

Jim.
0
 

Author Comment

by:pandav
ID: 6518844
Thanks.

Problem solved.

Regards
Pandav
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now