Mail Merge Word 2003 and Acess 2003 - Print Banner Page Possible

[Robert]

I do mail merges using Word 2003 and Acess 2003. The fields in Access are
sorted on 3 columns, Assistant, MD and CompanyName. In that order. This way
it groups the printouts by Assistant and for each assistant groups the
letters for the MD they are responsible for and I added companyname so I can
pick thru the pile and seperate the letters a little quicker. Just look for
next letter A in stack and i know where next MD letters begin.

Is there any way to have Word do something, maybe print a banner page when
the value in either the Assistant or MD field changes so I don't have to
manually seperate the letters. IOW: When the a new MD letters is being
printed a banner page is inserted so I know where to seperate the stack.

I could do seperate merges but thats more work, I think unless that can be
automated, than manually sperating letters. I created macros to automate the
merge process, would be nice to find a solution to the final piece of the
puzzle.

Any suggestions are greatly appreacited.

 

[Beth Melton]

Is there a reason you didn't use an Access report for this? An Access report
can easily do what you want.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx