Macro to capture printer tray number

Discussion in 'Word VBA' started by zirac, Mar 27, 2009.

  1. zirac

    zirac Guest

    Hi All

    We have a macro that prints a standard letter on two types of paper. One on
    plain and other on letterhead. We are now replacing our printer and I need
    to change the tray number on the macro but I have no idea what the printer
    number is. Is there a macro that capture the printer tray number?
    zirac, Mar 27, 2009
    1. Advertisements

  2. Karl Peterson has done a class moduile which enables you to know just about
    all there is to know about a printer.

    Hope this helps.

    Please reply to the newsgroup unless you wish to avail yourself of my
    services on a paid consulting basis.

    Doug Robbins - Word MVP, originally posted via
    Doug Robbins - Word MVP on, Mar 27, 2009
    1. Advertisements

  3. zirac


    Hi we spent a lot of time implementing macros to select printer trays for our law firm application. They became quite complex and a bit hard to maintain when we deployed new printers or upgraded drivers.

    We did eventually stumble upon a great little word plugin called Tray Selector at which wraps up all this. It allows you tocreate buttons in the ribbon bar or toolbars and configure each to print to a certain trays. It has worked well and saved us a lot of time.

    It is possible to use the macro solution too but it tends to get a bit messy and you need to know the Tray Numbers.
    , Aug 26, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.