Mailmerge and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IGISpokane - 03 Nov 2006 04:19 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 03 Nov 2006 05:21 GMT

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

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 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
[quoted text clipped - 13 lines]
>
> Mike

Reply to this Message