Normal Topic Print Issue (Read 1382 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Print Issue
Nov 1st, 2014 at 3:02am
Print Post Print Post  
I used to enjoy printing an envelope (or a bunch of envelopes) using two command buttons on Sesame (one for current record only and the other for retrieved records)

I am unable to get the printer to use the 1st tray which is where my envelopes are:

The printer I'm using is an HP Officejet Pro 8600

When I print from Word, it "magically" knows to go to tray 1 for envelopes and to tray 2 for letter-size paper.

From Sesame I can only get it to go to tray 2 . . . and if I remove tray 2 and force it to go to tray 1, I get an error "mismatch paper size" (or something like that)

Here's the portion of the programming pertaining to the print (it simply follows other programming that checks to see whether the address portion is incomplete, etc)

Code
Select All
{
AlternateDefaultPrinter("HP Officejet Pro 8600 - Envelopes")

Newpage(950,412)
PrintString("Spencer Wulwick", 30, 25, 0, "Arial", 14, 0)
PrintString("1901 N Andrews Ave", 30, @PageExtentY(), 0, "Arial", 14, 0)
PrintString("Wilton Manors, FL 33311-3928", 30, @PageExtentY(), 0, "Arial", 14, 0)

PrintString(Name, 450, 200, 0, "BArial", 16, 0)
PrintString(Address1 + " " + Apt, 450, @PageExtentY(), 0, "BArial", 16, 0)
PrintString(City + ", " + State + "  " + Zip, 450, @PageExtentY(), 0, "BArial", 16, 0)

FinishPage()
RestoreDefaultPrinter()
} 



I checked the programming guide and tried adding the following

Code
Select All
PrintPagePaper(Envelope)
PrintPageTray(1)
 



I've also tried (even though the manual says to use an integer
Code
Select All
PrintPageTray(Envelope)
 



I would appreciate help for 2 reasons.

(1) Ray suggested I use mail merge which I'm very interested in; however, I am having even more difficulty with that and,
(2) even if I did get mail merge working - which I hope I will - it is still more convenient to use the one button to print a single envelope directly from the record, without having to wait for Word to open up (and I'm not sure what else, since I can't get that far).

Thanks!
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Print Issue
Reply #1 - Nov 6th, 2014 at 1:16am
Print Post Print Post  
Hi -

I had been hoping to hear some suggestions from others.  Is anybody using print specs at all to print from a database?

I can't imagine that I would be the only one.

Looking forward to receiving some feedback.
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Print Issue
Reply #2 - Nov 21st, 2014 at 11:36pm
Print Post Print Post  
I used to have a printer with a separate tray, but it died, and my new printer does not have multiple trays, so I can't test any new configurations, but...

Here's what I used to use in my code, and it always worked well for me.
Code
Select All
PrintPagePaper(28)  // PRINT_PAPER_LETTER
PrintPageTray(7)  // PRINTER_TRAY_AUTO 



I noticed that you tried to enter just "Envelope" in PrintPagePaper(), but it would need to be "PRINT_PAPER_ENVELOPE", or just the integer of "30".

As far as the PrintPageTray() setting, you may need to experiment to find the right integer -- most likely "5", which is the same as using PRINTER_TRAY_ENVELOPE.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: Print Issue
Reply #3 - Nov 21st, 2014 at 11:59pm
Print Post Print Post  
Carl -

Had you been just a little bit quicker, you might have saved me some money.  (lol)  I wanted this fixed, and didn't appear to be getting any help here so I had Ray do it for me (under "focused" support). 

Anyhow, he did use the #30 (which I didn't have a clue about) and also the Paper Orientation.  Anyhow, it's working perfectly now. 

Thanks for the info.
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Print Issue
Reply #4 - Nov 23rd, 2014 at 10:31pm
Print Post Print Post  
Well, it's good to support Lantica once in a while with some financial support. Wink

They've released a lot of free updates over the years, so they certainly aren't greedy about it, and deserve some support back. Smiley
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged