Click to See Complete Forum and Search --> : Printing Envelopes


Jay Ashbridge
February 10th, 2000, 12:22 PM
I have a product that I would like to offer envelope printing in. I wrote a little Crystal Report that will put the return address and mailing address in the right place... on my printer! I can find a zillion report writers that support mailing labels but ZERO that even have the word envelope in their index. The problem is that different printers load the envelopes in different ways. MS Word seems to be able to handle this and prints the envelope properly for each printer. I just don't know how they do it. I suppose I could use OLE automation to take advantage of Word's functionality, but I can't assume that my customers have Word. I found one report writer (from VideoSoft) that supposedly will print any Access report without the user having Access. But even Access doesn't mention envelopes. Do I just give up and support mailing labels only?

February 14th, 2000, 12:00 AM
Exp: Printer.PaperSize = vbPRPSEnv9 / or = 19

PaperSize Property
vbPRPSEnv9 19 Envelope #9, 3 7/8 x 8 7/8 in
vbPRPSEnv10 20 Envelope #10, 4 1/8 x 9 1/2 in
vbPRPSEnv11 21 Envelope #11, 4 1/2 x 10 3/8 in
vbPRPSEnv12 22 Envelope #12, 4 1/2 x 11 in
vbPRPSEnv14 23 Envelope #14, 5 x 11 1/2 in

Exp: Printer.PaperBin = vbPRBNManual /or = 4
PaperBin Property
vbPRBNUpper 1 Use paper from the upper bin
vbPRBNLower 2 Use paper from the lower bin
vbPRBNMiddle 3 Use paper from the middle bin
vbPRBNManual 4 Wait for manual insertion of each sheet of paper
vbPRBNEnvelope 5 Use envelopes from the envelope feeder