Split tray printing on HP4000

[matthewh]

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

[Ivan F Moala]

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