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. 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 from High School A,
These students got scholarships:
Joe Smith $1000
Jane Doe $750
Thanks
Justin
{page break}
Dear Counselor B from High School B,
These students got scholarships:
Gerald Wright $1000
Joan Smith $750
Thanks
Justin
{page break} etc.
<colgroup><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
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. 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 from High School A,
These students got scholarships:
Joe Smith $1000
Jane Doe $750
Thanks
Justin
{page break}
Dear Counselor B from High School B,
These students got scholarships:
Gerald Wright $1000
Joan Smith $750
Thanks
Justin
{page break} etc.
c_name | f_name | m_name | l_name | sch_type | amt_1_yr | amt_4_yr | hs_code | hs_name |
Mr. Frank | Caitlin | W | Carlos | Merit Scholarship | $14,500 | $58,000 | 123142 | Saint Bernard School |
Mrs. Ashley | Joe | C | Smith | Leadership Scholarship | $2,500 | $10,000 | 245896 | Catholic High School |
Mrs. Ashley | Joe | C | Smith | Merit Scholarship | $14,000 | $56,000 | 245896 | Catholic High School |
Mrs. Ashley | Jamie | M | Cook | Leadership Scholarship | $11,500 | $46,000 | 245896 | Catholic High School |
Mrs. Ashley | Scott | T | Everett | Leadership Scholarship | $2,500 | $10,000 | 245896 | Catholic High School |
Mr. Josh | Richard | T | Sample | Merit Scholarship | $14,000 | $56,000 | 785489 | Ironwood High School |
Ms. Sam | Kristin | M | Anne | Leadership Scholarship | $8,500 | $34,000 | 785489 | Ironwood High School |
Mr. Greg | Dylan | M | Hauer | President Scholarship | $12,000 | $48,000 | 254587 | Verde High School |
<colgroup><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>