You'll want to do a catalog/directory (terminology depends on Office version) merge, there's a short tutorial here: HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000
Having a weird problem here that probably has an easy fix. We're trying to get a mail merge with student data on it including siblings. However if a student has more than one sibling then it creates more than one document (one document for each sibling).
Not sure how to give a better description really! Hope that someone has an idea.
SOLVED Typical I post here and we fix it. Added family links in once for each year group with Sibling Name then added a filter to that for each year group. Fiddly so if anyone has a simple answer that would be awesome.
Last edited by Trigger; 29th January 2014 at 12:04 PM.
That does look easier I'll have a play with that for next time thanks (I don't know why I get asked to do these things I haven't a clue!)
Do you use mailing points? Solves the issue perfectly. Only 1 mailing point per family, so filter for MPs then list all sibling details in it if required.
There are currently 1 users browsing this thread. (0 members and 1 guests)