collate pages in mail merge vs mail merge being single document

D

Dan Schwab

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
 
G

Guest

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.
 
D

Doug Robbins

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


--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top