Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Envelope printing from MS-Access.

Posted on 2001-09-12
3
Medium Priority
?
717 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 200 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 58
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

715 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