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.

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/tr...295841033.aspx

"Robert" <Robert@discussions.microsoft.com> wrote in message
news:088E619B-5139-48F2-BB16-836287362FCE@microsoft.com...
>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.