![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
||||
|
||||
![]()
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
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! |
#4
|
|||
|
|||
![]()
Solved! Thank you for your help, I was able to switch to Directory in mail merge and it worked!
|
![]() |
Tags |
mail merge, mail merge help, mail merge problem |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
NewGirl | Mail Merge | 1 | 11-15-2012 04:47 PM |
![]() |
ellinj | Word | 4 | 03-21-2011 05:12 PM |
Page break middle of table (word 2003) | mujisan | Word Tables | 1 | 06-18-2010 12:05 AM |
![]() |
englund33 | Word Tables | 1 | 06-15-2010 02:00 AM |
![]() |
Gozilla | Excel | 1 | 10-18-2009 08:50 PM |