MIS Systems Thread, [SIMS] Export Data with Multiple Siblings in Technical; Having a weird problem here that probably has an easy fix. We're trying to get a mail merge with student ...
29th January 2014, 11:52 AM #1
- Rep Power
[SIMS] Export Data with Multiple Siblings
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.
29th January 2014, 12:09 PM #2
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
29th January 2014, 12:26 PM #3
- Rep Power
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!)
1st February 2014, 06:19 PM #4
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.
By Will_Townsend in forum Educational IT Jobs
Last Post: 18th October 2013, 04:55 PM
By Banjo in forum MIS Systems
Last Post: 24th June 2013, 10:49 AM
By Juthely in forum MIS Systems
Last Post: 24th June 2012, 10:56 AM
By ctaylor in forum MIS Systems
Last Post: 14th September 2011, 11:05 PM
By LosOjos in forum MIS Systems
Last Post: 4th February 2011, 08:51 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)