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.