I have a sheet with 22 pages of forms, all separated with Page Headers. Some
of the pages get printed up to 20 times using Copies:=20 and so forth.
Although my macro currently steps through several variable comparisons and
prints each page if the value is greater than 0, this then makes my printer
print separate print jobs, which then collates them all and I have to rotate
the sheets and jog them up. This is then repeated 9 times so I end up jogging
and rotating up to 300 sheets of paper. The Collate:=False and Collate:=True
control has no effect. I've even tried pulling out the second paper tray, but
this just makes the printer hold back the print jobs that it wants to take
from that tray and waits until the tray is pushed in again and prints those
jobs anyway, which makes the sheets get out of order.

I've spent an hour reading posts and it seems that several people have this
problem in one form or another. Is it possible to create a statement or is
there already a statment that will print several pages of a sheet based a
string of numbers? I can establish the string ahead of time using similar
variable comparisons. Say, out of the 22 pages, my print job needs to print
pages 1,2,5,7,8,9,15,16. Does something like this exist ...

ActiveWindow.SelectedSheets.PrintOut From:=1, To:=2,5,7,8,9,15,16

or some variation of this?

There has to be a way to do this, I just can't figure it out.

Don