Mail Merge

I have a HP9000 with a saddle stich option which allows me
to make booklets. The limitation for a booklet is 40
pages. Currently I have a 36 page booklet that I wish to
use in a mail merge for 20 unique people. When the mail
merge is complete I end up with a document of 720 pages
(36 x 20). Now my printer will not make the booklets
because it thinks there are too many pages. How can I do
a mail merge like this and instruct the printer to start a
booklet after each 36th page??

Help.

Doug
Tue Nov 04 23:05:34 CST 2003

Hi Scott,

Execute the merge to a new document. This will result in a document having
20 sections, one for each merged record. Then use a macro containing the
following commands to send each section as a separate print job to the
printer

Dim i as Integer
For i = 1 to ActiveDocument.Sections.Count
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
"Scott Lefebvre" <scott@tbmpayroll.com> wrote in message
news:0eaf01c3a2e0$7d46ecc0$a401280a@phx.gbl...
> I have a HP9000 with a saddle stich option which allows me
> to make booklets. The limitation for a booklet is 40
> pages. Currently I have a 36 page booklet that I wish to
> use in a mail merge for 20 unique people. When the mail
> merge is complete I end up with a document of 720 pages
> (36 x 20). Now my printer will not make the booklets
> because it thinks there are too many pages. How can I do
> a mail merge like this and instruct the printer to start a
> booklet after each 36th page??
>
> Help.