Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
I need to add a "number" to each copy of a document I am preparing. I was
going to merge a field (for the serialization of each copy) from Excel but the 12-page document merges into 700+ sections with no breaks for the printer to know where to print another document. I want the document to print as booklets, separating after section 12, for example. Any ideas? |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
If you run a macro containing the following code after executing the Merge
to a new document, it will send each 12 pages to the printer as a separate print job: Dim i As Long With ActiveDocument For i = 1 To .Sections.Count .PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i Next 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, originally posted via msnews.microsoft.com "Scott" Scott @discussions.microsoft.com wrote in message ... I need to add a "number" to each copy of a document I am preparing. I was going to merge a field (for the serialization of each copy) from Excel but the 12-page document merges into 700+ sections with no breaks for the printer to know where to print another document. I want the document to print as booklets, separating after section 12, for example. Any ideas? |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Thanks, Doug! It worked like a charm, although Word crashed about halfway
through. But with each copy numbered, I knew exactly where to begin again. "Doug Robbins - Word MVP" wrote: If you run a macro containing the following code after executing the Merge to a new document, it will send each 12 pages to the printer as a separate print job: Dim i As Long With ActiveDocument For i = 1 To .Sections.Count .PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i Next 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, originally posted via msnews.microsoft.com "Scott" Scott @discussions.microsoft.com wrote in message ... I need to add a "number" to each copy of a document I am preparing. I was going to merge a field (for the serialization of each copy) from Excel but the 12-page document merges into 700+ sections with no breaks for the printer to know where to print another document. I want the document to print as booklets, separating after section 12, for example. Any ideas? |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge from excel "-" instead of number zero and "()" for neg | Mailmerge | |||
email merge with multiple recipients in "To", "CC" & "BCC" | Mailmerge | |||
"remove blank lines"+"Mail Merge" | Mailmerge | |||
"mail merge" disappeared from "tools" menu | Mailmerge | |||
Mail Merge - Fields missing within "insert merge field" tab | Mailmerge |