Thread: Setting Trays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Setting Trays

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



On Fri, 29 Jan 2010 13:05:01 -0800, Don
wrote:

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?