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.

Attached Files

	list_test_data.xls (24.5 KB, 8 views)
	Test Letter.doc (29.5 KB, 8 views)