Excel list to Word with Page Break on new unique data

[jeverett1]

Hello Experts,

I using Word 2013 to mail merge. I have a large list of data (counselor names, student names, scholarships and high schools). I want to mail merge the list so that each counselor gets one letter, but they may have multiple students (unique field is hs_code). I have tried everything I know, reading this forum, consulting with my IT guys and nothing seems to work. I have attached test data and a Word doc with Merge Fields I have come up with so far. I may be waaaay off. Can some one help?

Thank you in advance. I hope to use any code provided that works for multiple projects, this would save me a ton of time in the future.

Example:

Dear Counselor A,

These students got scholarships:
Joe Smith $1000
Jane Doe $750



Thanks
Justin

{page break}

Dear Counselor B,

These students got scholarships:
Gerald Wright $1000
Joan Smith $750

Thanks
Justin

{page break} etc.

[macropod]

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://windowssecrets.com/forums/sho...merge-Tutorial
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.

For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327

[jeverett1]

Thanks for the response Paul!

Attached you will find what I came up with, but it still will not list all the students for "Mrs. Ashley" in one letter. I am at a loss!

[jeverett1]

Solved! Thank you for your help, I was able to switch to Directory in mail merge and it worked!