Setting Trays

[Don]

I have a client that has a 5 page report. They want the 1st and 5th printed
to blank paper while the 2,3 and 4 pages go to a Letterhead page. Any
suggestions? Can you somehow set the trays the part of the report will go to?

 

[Gord Dibben]

Only by creating two separate print jobs or manipulating paper placement in
a tray.

You could do it with a macro but would still be two separate print jobs.

Record a macro whilst printing Page1 and Page5 to one tray then print 3.4.5
to other tray.

Or simply insert blank sheets at appropriate spots in letterhead tray and
print all pages.

i.e. 1 blank, 3 letterhead, 1 blank


Gord Dibben MS Excel MVP