HELP!!!
Tried 2 different printers with seperate queues, worked ok for 3 people then got it all mixed up due to being in seperate queues. Is there a way to do this in the same printer queue (See below)? I need to get these printing ASAP!
Previous Post...
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
Tried 2 different printers with seperate queues, worked ok for 3 people then got it all mixed up due to being in seperate queues. Is there a way to do this in the same printer queue (See below)? I need to get these printing ASAP!
Previous Post...
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