print mail merge documents that are mult ipaged

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yehoshua24 - 06 Jul 2006 01:01 GMT

I have a document that is 16 pages that I am using mail merge to import
various information from a database. When I do a mail merge my document is
4600 pages. My printer is able to correlate and staple. However I have no
idea how to run the mail merge so that it will print each record as a
separate print job without doing each record individually. Does any one know
how to do this?

Reply to this Message

Doug Robbins - Word MVP - 06 Jul 2006 04:11 GMT

Use a macro containing the following code on the 4600 page document:

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

It will send each 16 page letter to the printer as a separate print job

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 have a document that is 16 pages that I am using mail merge to import
> various information from a database. When I do a mail merge my document is
[quoted text clipped - 3 lines]
> know
> how to do this?

Reply to this Message