#1   Report Post  
Posted to microsoft.public.excel.misc
Don Don is offline
external usenet poster
 
Posts: 487
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
setting default filter setting tpeter Charts and Charting in Excel 0 December 4th 09 02:50 PM
priority setting Formatting Excel Discussion (Misc queries) 0 April 1st 09 06:50 PM
Setting up a form srod Excel Discussion (Misc queries) 1 March 27th 09 06:02 PM
Printing to seperate printer trays................... Steve Jones Excel Discussion (Misc queries) 1 September 30th 08 08:56 PM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM


All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"