Mail Merge

[Scott Lefebvre]

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 Robbins - Word MVP]

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