[SIMS] Export Data with Multiple Siblings

[Trigger]

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.

Edited January 29, 2014 by Trigger

[LosOjos]

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

[Trigger]

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!)

[vikpaw]

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.