Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Split tray printing on HP4000

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Scenario:

    I need to print a personalised letter on plan paper and the same data into a pre-printed form on an HP 4000 printer. Each letter is accompanied by 10 copieds of the same pre-printed form, and I have several thousand to do. I need to have them colated like this otherwise it'll take hours

    The forms are held in Tray 2 and the plain paper in tray 1.

    Question:

    Is there a way from Excel to diferentiate between the 2 trays? If I record a macro using the 2 different trays I get

    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

    and eveything prints out on Tray 2 (default).

    Has anyone successfully done this before?

    Matt

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-15 01:42, matthewh wrote:
    Scenario:

    I need to print a personalised letter on plan paper and the same data into a pre-printed form on an HP 4000 printer. Each letter is accompanied by 10 copieds of the same pre-printed form, and I have several thousand to do. I need to have them colated like this otherwise it'll take hours

    The forms are held in Tray 2 and the plain paper in tray 1.

    Question:

    Is there a way from Excel to diferentiate between the 2 trays? If I record a macro using the 2 different trays I get

    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

    and eveything prints out on Tray 2 (default).

    Has anyone successfully done this before?

    Matt
    Excel is limited in its print functions.
    I'd suggest 2 things
    1) Use send keys !?
    2) Set up your printer as a New printer
    and name it something eles. Set the
    defaults to Tray 2 on his one
    and on the other set to Tray 1


    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •