print booklets together with mail merge

[Seppe]

Hi
i want to print booklets on a4 folded to a5.
Each booklet contains results of a test fthat are stored in an excelfile.
If i create this booklets they get into one hugh file that is folded into
one booklet.
Is there an option to create 5 12-paged booklets instead of one booklet with
60 pages.

Thanks in advance

 

[Mary Sauer]

Could you explain a little clearer on what you are doing?

What is stored in the Excel file? Have you created a booklet and want to merge
data?

 

[Seppe]

Mary

The excelfile containes rows with results for a sportstest of 20 students.
Name ;result test1 ;result test2; result test 3; ...;

Those data are merged to the booklet that counts 12 pages.
When i merge the data it reads data for every student and places it
correctly in the booklet.

The problem is that i end up with one booklet of 20 * 12 = 240 pages while i
want 20 12-paged booklets, each containing info of one student.

Is this possible?

 

[Seppe]

Maybe this explains some more:
I want my copier to staple every booklet.
Now publisher creates one file containing the pages for 20 booklets and my
printer tries to staple this.

Hopefully this is a bit clear ...

 

[Mary Sauer]

Can you not simply create one booklet at a time? What version Publisher? Have
you looked into step 5 or step 3 in the merge wizard where you can create new
publications?

Have you read Ed's article?
The Registry Fix
for changing the Mail Merge Batch Size
http://ed.mvps.org/Static.aspx?=Publisher/registryfix

 

[Seppe]

Thank you,

Ed's regkey helped me solve the problem.