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
    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.

    http://vb.mvps.org/samples/project.asp?id=PrnInfo


    --
    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 msnews.microsoft.com

    "zirac" <> wrote in message
    news:...
    > 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?
     
    Doug Robbins - Word MVP on news.microsoft.com, Mar 27, 2009
    #2
    1. Advertisements

  3. zirac

    Guest

    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 http://us.trayselector.com 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.

    On Friday, 27 March 2009 22:00:46 UTC, Doug Robbins - Word MVP on news.microsoft.com wrote:
    > Karl Peterson has done a class moduile which enables you to know just about
    > all there is to know about a printer.
    >
    > http://vb.mvps.org/samples/project.asp?id=PrnInfo
    >
    >
    > --
    > 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 msnews.microsoft.com
    >
    > > 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?
     
    , Aug 26, 2013
    #3
    1. Advertisements

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.
Similar Threads
  1. Al & Cay Grant

    Printer tray selection...again....

    Al & Cay Grant, Sep 17, 2003, in forum: Word VBA
    Replies:
    5
    Views:
    200
    Jonathan West
    Sep 17, 2003
  2. BRC
    Replies:
    2
    Views:
    352
  3. John C Brainard

    Insert Section Break for Printer Tray Change

    John C Brainard, Apr 23, 2005, in forum: Word VBA
    Replies:
    0
    Views:
    108
    John C Brainard
    Apr 23, 2005
  4. Laura
    Replies:
    3
    Views:
    345
    Laura
    Feb 8, 2006
  5. David Rowell
    Replies:
    5
    Views:
    457
    David Rowell
    Apr 21, 2007
  6. mr t
    Replies:
    1
    Views:
    235
    Graham Mayor
    Jun 14, 2007
  7. Graham Mayor
    Replies:
    2
    Views:
    360
    Graham Mayor
    May 1, 2008
  8. Sivakumar
    Replies:
    1
    Views:
    343
    Graham Mayor
    Jun 4, 2010
Loading...