Mail Merge Staple 2

[alv7ter]

MS Word 2003
I need mail merge to allow me to collate and staple individual copies that are sent to a duplex printer. Mail merge seems to think that all the copies are one document and tries to staple them all together.

Does anyone have a fix for this?
Al

 

[SkipVought]

Hi,

Here is a general approches.

1. Use the View Merged Data toggle to DISPLAY the data in each MM Field.

2. I simple macro recorded printing & advancing the record and added a for...next loop

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 11/27/2006 by SkipVought
'
    For i = 1 To ActiveDocument.MailMerge.DataSource.RecordCount
        ActiveDocument.PrintOut
        ActiveDocument.MailMerge.DataSource.ActiveRecord = wdNextRecord
    Next
End Sub

Skip,

_[red][/red]

 

[TonyJollans]

If you have Word 2003 (or maybe 2002) take a look at Doug Robbins' MMtoDocs AddIn - it's available from Graham Mayor's Download's Page. When each Merge result is in a separate document you can then print them all and they will be stapled individually.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[alv7ter]

Thanks Skip, that worked a treat. Cheers, Al.

 

[arcp]

Skip-

You are awesome!!!!!!!

I can't believe that this works. This will save me a lot of time at work.

Again, Thank you so much Skip!!!!!!!!!!