This solution covers locating tray calls for use with Microsoft Office macros. These macros tend to be manually recorded within the application by setting the desired paper tray within Page Setup. This records a specific numerical reference based off the default printer driver. Once one of these actions is recorded the macro can be replicated and the number updated as required.


The attached executable prdevcap.exe extracts information out of a Windows print queue and can be used to discovery these numbers from the Command Prompt.


Syntax:

C:\<file path>\prdevcap.exe "<full name of print queue>" > c:\temp\<useful file name>.txt


Example:

C:\temp\prdevcap.exe "Xerox WorkCentre 7845 PS" > c:\temp\7845.txt


(If c:\temp\ is ignored to the right of the greater than symbol, the file is output into the same folder as the prdevcap.exe)


Inside the output file, there is 'DC_BINS' and 'DC_BINNAMES' which shown the identifying number and the related paper tray number for that particular print driver. They are in consecutive sections of the output, and need to be directly matched up. If the X-GPD is used, each model selected will change the Bin-Tray combination.


Further more detailed information can be found in the attached prdevcap.doc


Sample final output below:


WorkCentre 7845 - Device Specific Driver


Paper Bin: Device Specific (258)

Tray 5

Paper Bin: Device Specific (259)

Tray 4

Paper Bin: Device Specific (260)

Tray 3

Paper Bin: Device Specific (261)

Tray 2

Paper Bin: Device Specific (262)

Tray 1

Paper Bin: Device Specific (9134)

Transparency

Paper Bin: Device Specific (9138)

Bond

Paper Bin: Device Specific (9139)

Labels

Paper Bin: Device Specific (9141)

Custom Type 1

Paper Bin: Device Specific (9142)

Custom Type 2

Paper Bin: Device Specific (9143)

Custom Type 3

Paper Bin: Device Specific (9144)

Custom Type 4

Paper Bin: Device Specific (9145)

Custom Type 5

Paper Bin: Device Specific (9146)

Custom Type 6

Paper Bin: Device Specific (9147)

Custom Type 7

Paper Bin: Device Specific (9148)

Plain

Paper Bin: Device Specific (9149)

Envelope

Paper Bin: Device Specific (9231)

Lightweight Cardstock R

Paper Bin: Device Specific (9233)

Glossy Cardstock

Paper Bin: Device Specific (9234)

Cardstock

Paper Bin: Device Specific (9235)

Lightweight Cardstock

Paper Bin: Device Specific (9236)

Heavyweight Cardstock

Paper Bin: Device Specific (9240)

Lightweight

Paper Bin: Device Specific (9241)

Pre-Printed

Paper Bin: Device Specific (9242)

Hole Punched

Paper Bin: Device Specific (9244)

Plain Reloaded

Paper Bin: Device Specific (9245)

Cardstock Reloaded

Paper Bin: Device Specific (9246)

Heavyweight Cardstock R

Paper Bin: Device Specific (9249)

Lightweight Glossy Card

Paper Bin: Device Specific (9250)

Lightweight Glossy Ca~1

Paper Bin: Device Specific (9251)

Glossy Cardstock Reload

Paper Bin: Device Specific (9252)

Heavyweight Glossy Card

Paper Bin: Device Specific (9253)

Heavyweight Glossy Ca~1

Paper Bin: Device Specific (9257)

Printer Default Type

Paper Bin: Device Specific (9259)

Recycled

Paper Bin: Device Specific (9262)

Letterhead

Paper Bin: Device Specific (9287)

Automatically Sele~1