Reply
 
Thread Tools Display Modes
  #1   Report Post  
Dan Schwab
 
Posts: n/a
Default collate pages in mail merge vs mail merge being single document

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
  #2   Report Post  
 
Posts: n/a
Default

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.
  #3   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"Dan Schwab" Dan wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
Mail merge, sheets, and pages. Johnny N Page Layout 2 February 9th 05 11:04 AM
Mail Merge is creating blank pages between form letters JW Mailmerge 1 January 25th 05 10:54 PM
Number of pages incorrect while doing mail merge Eadie Mailmerge 0 January 21st 05 03:53 PM
How do I print a mail merge w/o the blank pages? Marios Mailmerge 3 December 29th 04 02:33 AM


All times are GMT +1. The time now is 03:37 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"