Priscilla_Hora
asked on
Word Template - Tray ID issue
I have two type of printers in my company. HP4300TN and HP4350TN.
We have a number of word 2000 templates which work fine with the 4300TN, whereby when a user prints it automatically defaults to letterhead paper as specified in the paper source tab in the page setup.
My problem occurs when my default printer is set to the 4350TN printer. The word template changes the paper source to Light 60-75 g/m2. So when the user prints, the printer freaks out as it cannot find the Light Tray as the tray is configured to letterhead.
After doing some research I found out that the problem lies in the tray ID. On the HP 4300 the letterhead paper type is set to id: 1265 and on the 4350 the light paper has the same id of: 1265. So when you change printers from 4300 to 4350 the word template changes the paper source from letterhead to light and vice versa.
How can I resolve this issue? Is it possible to add a VBA script to the template saying:
If your printer is a 4300 change the paper source to letterhead or tray id:1265
If you printer is a 4350 change the paper source to letterhead or tray id:1271 (NOT 1265, which is what it is doing now)
Anyone can help.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hmm, it seems that you have also posted this question in the Word area:
https://www.experts-exchange.com/questions/21895137/Template-selecting-different-paper-type-for-different-printers.html
and that gBhari has given a similar answer.
I think we'll have to wait and see if the moderators come across it and let them sort it out.
https://www.experts-exchange.com/questions/21895137/Template-selecting-different-paper-type-for-different-printers.html
and that gBhari has given a similar answer.
I think we'll have to wait and see if the moderators come across it and let them sort it out.
ASKER
Where would I put the code in so that it automatically checks which printer is connected upon opening the template?
I don't want this to be a button where a user clicks on, this process has to be invisible to the user.
I don't want this to be a button where a user clicks on, this process has to be invisible to the user.
Put these calls in the ThisDocument Module of your template:
Private Sub Document_New()
PrinterTrays
End Sub
Private Sub Document_Open()
PrinterTrays
End Sub
Private Sub Document_New()
PrinterTrays
End Sub
Private Sub Document_Open()
PrinterTrays
End Sub
https://www.experts-exchange.com/questions/21895174/Word-template-Change-Paper-source.html
looks like the same question, but worded differently.
As far as I can see the, the answer would be the same as for this one.
You are not allowed to offer more than 500 points for the same question. However you while it has no comments you would be able to delete it yourself.
If you think it's essentially a different question, perhaps you could add a comment explaining the differnce that so that an expert can address that different question.