Mailmerge and Excel

[IGISpokane]

I have a minolta 75 ppm machine with a folding finisher on it. I have
created a word document and an excel spreadsheet to do a mail merge mailing.
I want to do a half fold on legal paper. The machine will accomplish this
task when printed without the mail merge component. As soon as I introduce
the mail merge the folding feature does not work. If I reprint the orginal
document without the mail merge everything comes out as I need.

Both applications are 2002 version.

Any and all suggestions and ideas are welcome

Thanks

Mike

 

[Doug Robbins - Word MVP]

You will probably need to execute the mailmerge to a new document and then
use a macro to send each letter to the printer as a separate print job. The
following is the code that you will need to do that

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