Link grandparents as couples to grandchildren in a flattened list with all grandchildren for that couple

We have a Grandparents Day and send invitations.  We like to address it to the grandparents (M/M Tom Smith, 111 Main St, Anytown, AL 35000) and include a mention of their grandchildren and the child's grade (Susie Smith, Grade 3). So we need a flattened list to do a mail merge with all that information on one line for each grandparent couple.  As it stands now, we can either get the M/M for the envelope and have to type in all 330 students or we can get each grandparent on a line with all the children and then have to "marry" the individuals by typing M/M and then deleting the other grandparent from the speradsheet.  VERY time consuming. 

  • Guest
  • Feb 23 2016
  • Attach files
  • Guest commented
    April 12, 2016 13:55

    We do this exact same thing and it's a huge pain. I had to write a custom application to get everything formatted correctly, which is unacceptable. I'm so tired of not being able to get the information I need out of WH.