collate pages in mail merge vs mail merge being single document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Schwab - 14 Sep 2005 17:02 GMT

I am trying to merge 1,800 names into a mail merge document that is 18 pages
long. I will end up with 18 pages X 1,800 names. Mail merge makes this one
document. I can't offset each one of the 1,800 on my printer because of
this. Is there something I can do to make this 1,800 seperate print jobs so
I can offset each set of 18 pages

Reply to this Message

larrynospam@nospamjbmsystems.com - 14 Sep 2005 17:39 GMT

Hi,

Using OctoTools for this application can do the Job. OctoTools can output
either PDF or print output and can break the files into individual jobs,
email or post the output automatically as well. OctoTools has a built in
mail merge capability and will take your rtf word docs and merge with your
text or database information (Access or MySQL). This is a commercial
application that is designed to run automatically with medium to high volume
throughputs and not justified for smaller desktop one-time runs. If
interested please give me a call at 978 535-7676 (Boston, MA USA) and I can
fill you in with more detail. OctoTools can be found at www.octotools.com .
Thanks for your time and I hope this is of use.

Larry T.

Reply to this Message

Doug Robbins - 14 Sep 2005 21:35 GMT

If you run the following macro when the document created by executing the
merge is the active document, it will send the set of 18 pages for each
record to the printer as a separate print job.

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to merge 1,800 names into a mail merge document that is 18
>pages
[quoted text clipped - 4 lines]
> so
> I can offset each set of 18 pages

Reply to this Message