Report 3 pages per sheet of paper - top 1-10 middle 11-20 bottom 2

D

David Widener

I am trying to print 3 pages per sheet of 8 1/2 by 11 paper the report is not
a problem but what I need is if there are 30 pages then the 1 through 10
would be on the top of the 10 sheets of paper then 11 through 20 would be in
the middle of the 10 sheets of paper and 21 through 30 would be on the bottom
of the 10 sheets of paper, any help would be appreciated...
 
D

David Widener

Joseph,
Yes this report is a Microsoft Access Report, maybe I just was not clear but
if you set the length of a report so that three pages will fit on a sheet of
paper the first sheet of paper will have 1st page on the top of the 1st sheet
2nd page in the middle of the 1st sheet and the 3rd page on the bottom of the
first sheet then the 4th page will be on the top of the 2nd sheet of paper
and so on, but what I need is if there are 30 pages then the 1st through 10th
page would be on the top of 10 sheets of paper then 11 through 20 would be in
the middle of the 10 sheets of paper and 21 through 30 would be on the bottom
of the 10 sheets of paper, this is perforated paper and I wish to tear the
top off in one tear stack it on the top of the middle then tear off the
middle in one tear stack it on the top of the bottom and have everything in
order, and like I said before any help would be appreciated...
 
L

Larry Daugherty

Hi David,

You haven't given us a clue as to the amount of work involved in your
current process and how much work will remain in any higher level of
automation. At first blush it looks to me like there'll be quite a bit of
manual work left; no matter how well you automate the rest of it. You have
perf and fold issues to deal with and you're going to have manual
separation/tear-offs with concatenation as a final step. It wouldn't be
worth the trouble to automate unless it's a process that you are doing
extremely frequently.

I recommend that you act as the calculator to resolve how many sheets total
in your print job and where the breaks will be. In your example given,
you'd print sheets paper 21 - 30 first. That will be Report pages 61 - 90.
Set the number of copies as required. Next print paper sheets 11 20 which
are Report pages 31 - 60. Same number of copies as before. Last, print
paper sheets 1 - 10 which are Report pages 1 - 30. Copies as before.

I thought/hoped that it might be possible to print the sections as Snapshot
files and then loop thru them with Script. Unfortunately, WSH doesn't have
a printer object so any print command has to be passed as a command line
option to the target application.

You may be able to find out something useful in the scripting groups.

HTH
 
Top