Merged files not individually collated and stapled when word print

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

psy UK - 19 Sep 2007 10:20 GMT

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

Reply to this Message

Graham Mayor - 19 Sep 2007 10:30 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Merged documents containing several records are not individually
> collated and stapled when you use the mail merge feature to print in
[quoted text clipped - 5 lines]
>
> Many thanks

Reply to this Message

psy UK - 19 Sep 2007 11:50 GMT

Excellent - many thanks

> You should be able to do this with one of fellow MVP Doug Robbins handy
> merge macros
[quoted text clipped - 25 lines]
> >
> > Many thanks

Reply to this Message

scottagalloway@gmail.com - 12 Oct 2007 17:46 GMT

> You should be able to do this with one of fellow MVP Doug Robbins handy
> merge macros
[quoted text clipped - 33 lines]
>
> > 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 to this Message

Peter Jamieson - 12 Oct 2007 21:13 GMT

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.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>> You should be able to do this with one of fellow MVP Doug Robbins handy
>> merge macros
[quoted text clipped - 43 lines]
>
> Scott

Reply to this Message