how do I get Word to recognize a merged file as seperate documents

[hiz5]

I have a 6 page Word document that I am using in a Merge. I have a merge
field in the heading of the document that enters the name of the company from
an Excel spreadsheet. When I merge the document and print it, Word is seeing
my document as one large document instead of 200 individual letters, so I am
not able to use the staple feature on the printer. What can I do to get Word
to recognize 200 individual letters of 6 pages rather than one document of
1,200 pages?

 

[Doug Robbins - Word MVP]

If you execute the merge to a new document and then run a macro containing
the following code, it will send each 6 page letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 1
.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

 

[hiz5]

Thank you. I will try it tomorrow.
--
hiz5

If you execute the merge to a new document and then run a macro containing
the following code, it will send each 6 page letter to the printer as a
separate print job, so that the printer can then do its thing as it does
when printing a single letter.

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 1
.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