Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multi doc mailmerge Collate+Staple
We have 3 different sets of Word docs.
They all get personalization info and have multiple pages. We need to merge and staple each set individually, then slip sheet a blank sheet to complete each package. --- We have macros for this in Access, any thoughts in how to incorporate this with Word? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multi doc mailmerge Collate+Staple
Does the personalization info for all three documents come from the one
datasource?, or can you combine the datasources so that all three documents can be personalized from that source? If so, you could then combine the three mail merge main documents into one, including a blank page either before the first page or after the last page, or in both places if that is where you want them and then if you execute the merge to a new document, you can run the following macro over that document to send each set of three documents to the printer as a separate print job so that they can be stapled by the printer: 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 -- 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 "notv788" wrote in message ... We have 3 different sets of Word docs. They all get personalization info and have multiple pages. We need to merge and staple each set individually, then slip sheet a blank sheet to complete each package. --- We have macros for this in Access, any thoughts in how to incorporate this with Word? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multi doc mailmerge Collate+Staple
Thank you so very much!
Once inserting the section breaks, this flew without a hitch! --- "Doug Robbins - Word MVP" wrote: Does the personalization info for all three documents come from the one datasource?, or can you combine the datasources so that all three documents can be personalized from that source? If so, you could then combine the three mail merge main documents into one, including a blank page either before the first page or after the last page, or in both places if that is where you want them and then if you execute the merge to a new document, you can run the following macro over that document to send each set of three documents to the printer as a separate print job so that they can be stapled by the printer: 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 -- 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 "notv788" wrote in message ... We have 3 different sets of Word docs. They all get personalization info and have multiple pages. We need to merge and staple each set individually, then slip sheet a blank sheet to complete each package. --- We have macros for this in Access, any thoughts in how to incorporate this with Word? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple page merge doc with multi sections, need to staple | Mailmerge | |||
Why doesn't Collate work in Word 2003? | Microsoft Word Help | |||
Trying to suppress Select Table box in Excel-Word mailmerge | Mailmerge | |||
Word documents won't collate, even though collate box is checked. | Microsoft Word Help | |||
Included Property in Word 2003 MailMerge | Mailmerge |