Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge and Excel
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge and Excel
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 "IGISpokane" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print an Excel Autoshape on a Word doc using mailmerge? | Mailmerge | |||
mailmerge using Word/Excel 500.00 in Excel shows as 500 nt 500.00 | Mailmerge | |||
Excel as mailmerge data source | Mailmerge | |||
excel hangs in mailmerge | Microsoft Word Help | |||
Mailmerge from EXCEL, custom format problem | Mailmerge |