+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1

    Join Date
    Feb 2013
    Posts
    34
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    3

    [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 11:04 AM.

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    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

  3. #3

    Join Date
    Feb 2013
    Posts
    34
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    3
    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!)

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 18th October 2013, 03:55 PM
  2. [SIMS] Capita - SIMS, SEN data export issues
    By Banjo in forum MIS Systems
    Replies: 0
    Last Post: 24th June 2013, 09:49 AM
  3. [SIMS] CMIS to SIMS Migration - Data Missing
    By Juthely in forum MIS Systems
    Replies: 19
    Last Post: 24th June 2012, 09:56 AM
  4. Replies: 30
    Last Post: 14th September 2011, 10:05 PM
  5. [SIMS] Batch export marksheets with summary rows
    By LosOjos in forum MIS Systems
    Replies: 15
    Last Post: 4th February 2011, 07:51 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •