ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Setting Trays (https://www.excelbanter.com/excel-discussion-misc-queries/254832-setting-trays.html)

Don

Setting Trays
 
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

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?




All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com