Mail Merge: New Page when data changes

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://www.msofficeforums.com/mail-m...-tutorial.html
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

Depending on what you're trying to achieve, the field coding for this can be complex. However, since the tutorial document includes working field codes for all of its examples, most of the hard work has already been done for you - you should be able to do little more than copy/paste the relevant field codes into your own mailmerge main document, substitute/insert your own field names and adjust the formatting to get the results you desire. For some worked examples, see the attachments to the posts at:
http://www.msofficeforums.com/mail-m...html#post23345
http://www.msofficeforums.com/mail-m...html#post30327

Another option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
Conversely, if you're using a relational database or, Excel workbook with a separate table with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at:
https://answers.microsoft.com/en-us/...f-8642e46fa103
For a working example, see:
http://www.msofficeforums.com/mail-m...-multiple.html

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

The tutorial includes fully working code. The Introduction tells you how to access it.

Unless you care to share your mailmerge main document showing what you've done, there's nothing much I can do to help with "I just couldn't make it work"...

I am not aware of any attachment issues here - I've attached many files to different posts to date. Just make sure your file formats & sizes are correct and that they're not open when you try to attach them.

I don't see any indication from your document that you've tried to implement anything demonstrated in the tutorial - it's not even configured as a Directory merge. I don't propose to do the basics for you - that way you'll never learn. When you've implemented the appropriate example from the tutorial, should you still be having difficulty, attach the relevant document to a post and we can go from there.

Thanks for the input but despite your thought, I have tried. My apologies I simply just do not understand nor follow what you have outlined. I did try to add the key and I do realize that I failed horribly at the task. I found it hard to follow your instructions to make it work to my needs. I guess I had different expectations as to the help provided here.

Just because my outcome was not what you expected, does not mean that I didn't even try.

Thanks
Guy

The instruction in the ‘Mailmerge Main Document’ file tell you what you need to do (i.e. read the tutorial before using that document). If you can't even get that document to work, it seems pretty obvious you haven't followed the fairly simple instructions found under 'Using the Sample Data File & Mailmerge Main Document'. Simply having the documents open side-by-side won't achieve anything - you need to copy the fields you want to experiment with from the tutorial to the ‘Mailmerge Main Document’ file.