Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged files not individually collated and stapled when word print
Merged documents containing several records are not individually collated and
stapled when you use the mail merge feature to print in word, i.e. 1 document is printed and stapled on the printer. I have seen the knowledge based article detailing how to do the same thing in Publisher by changing values in regedit. Does a similar answer exist in relation to word. Many thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged files not individually collated and stapled when word print
You should be able to do this with one of fellow MVP Doug Robbins handy
merge macros Sub SplitMergeLetterToPrinter() ' splitter Macro ' Macro created 16-08-98 by Doug Robbins to print each letter created by a ' mailmerge as a separate file. ' Letters = ActiveDocument.Sections.Count Counter = 1 While Counter Letters ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _ From:="s" & Format(Counter), To:="s" & Format(Counter) Counter = Counter + 1 Wend End Sub -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org psy UK wrote: Merged documents containing several records are not individually collated and stapled when you use the mail merge feature to print in word, i.e. 1 document is printed and stapled on the printer. I have seen the knowledge based article detailing how to do the same thing in Publisher by changing values in regedit. Does a similar answer exist in relation to word. Many thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged files not individually collated and stapled when word p
Excellent - many thanks
"Graham Mayor" wrote: You should be able to do this with one of fellow MVP Doug Robbins handy merge macros Sub SplitMergeLetterToPrinter() ' splitter Macro ' Macro created 16-08-98 by Doug Robbins to print each letter created by a ' mailmerge as a separate file. ' Letters = ActiveDocument.Sections.Count Counter = 1 While Counter Letters ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _ From:="s" & Format(Counter), To:="s" & Format(Counter) Counter = Counter + 1 Wend End Sub -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org psy UK wrote: Merged documents containing several records are not individually collated and stapled when you use the mail merge feature to print in word, i.e. 1 document is printed and stapled on the printer. I have seen the knowledge based article detailing how to do the same thing in Publisher by changing values in regedit. Does a similar answer exist in relation to word. Many thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged files not individually collated and stapled when word print
On Sep 19, 3:30 am, "Graham Mayor" wrote:
You should be able to do this with one of fellow MVP Doug Robbins handy merge macros Sub SplitMergeLetterToPrinter() ' splitter Macro ' Macro created 16-08-98 by Doug Robbins to print each letter created by a ' mailmerge as a separate file. ' Letters = ActiveDocument.Sections.Count Counter = 1 While Counter Letters ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _ From:="s" & Format(Counter), To:="s" & Format(Counter) Counter = Counter + 1 Wend End Sub -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org psy UK wrote: Merged documents containing several records are not individually collated and stapled when you use the mail merge feature to print in word, i.e. 1 document is printed and stapled on the printer. I have seen the knowledge based article detailing how to do the same thing in Publisher by changing values in regedit. Does a similar answer exist in relation to word. Many thanks I would like to use this macro but don't know where to start with word macros. How do i take the snipit of text above and use it to create a macro in word. then at what point in the mail merge process do i run the macro? Thanks, Scott |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merged files not individually collated and stapled when word print
You could look around Graham Mayor's site a bit more -
http://www.gmayor.com/installing_macro.htm or see http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm then at what point in the mail merge process do i run the macro? In this case you probably need to set up the mail merger main document, connect it to the data source, then run the macro. -- Peter Jamieson http://tips.pjmsn.me.uk wrote in message oups.com... On Sep 19, 3:30 am, "Graham Mayor" wrote: You should be able to do this with one of fellow MVP Doug Robbins handy merge macros Sub SplitMergeLetterToPrinter() ' splitter Macro ' Macro created 16-08-98 by Doug Robbins to print each letter created by a ' mailmerge as a separate file. ' Letters = ActiveDocument.Sections.Count Counter = 1 While Counter Letters ActiveDocument.PrintOut Background:=False, Range:=wdPrintFromTo, _ From:="s" & Format(Counter), To:="s" & Format(Counter) Counter = Counter + 1 Wend End Sub -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org psy UK wrote: Merged documents containing several records are not individually collated and stapled when you use the mail merge feature to print in word, i.e. 1 document is printed and stapled on the printer. I have seen the knowledge based article detailing how to do the same thing in Publisher by changing values in regedit. Does a similar answer exist in relation to word. Many thanks I would like to use this macro but don't know where to start with word macros. How do i take the snipit of text above and use it to create a macro in word. then at what point in the mail merge process do i run the macro? Thanks, Scott |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
word document pages # consecutively, section page # individually | Microsoft Word Help | |||
How to print collated merged forms | Mailmerge | |||
When printing 2 or more docs to be stapled, all docs come stapled | Microsoft Word Help | |||
I want to print business cards that are individually numbered. | Microsoft Word Help | |||
Sending Merged Documents to Printer Individually | Mailmerge |