Thanks for the thorough reply and explanation of the thought process. I agree with you conceptually - just trying to figure out the best way to get to that end point. It's not that important that we address the child by name - just generally by grade. However, occasionally we might use this to look up a child to find out who their parent/email is - but that's a minor need. We receive the data en masse each year in an excel spreadsheet where each row is a student and then in that row we can have between 1 and 5 email addresses. But for now we can just solve for one email address. The issue comes up with siblings so in our excel sheet we may have 3 rows (3 different students who are all siblings in different grades) and they all have the same email address (these are elementary students so we have a parent email). Grade is also a value on their excel row. So an example of 3 rows I might have are: John Smith - Grade 2 - mamasmith@... Jane Smith - Grade 4 - mamasmith@.... Jim Smith - Grade 5 - mamasmith@.... If I uploaded these 3 records as is, my understanding is I would end up with one constant contact record with the name and grade of whichever record is the final one processed. At a minimum what I need to end up with is a constant contact record with mamasmith email and then either tags for each grade they are in, or mamasmith to be in 3 different lists, one for each grade she has kids in. If we can get the kids names in too, great - but I could live without it if I can just tie the parent to grades in as automated a way as possible. I'm trying to figure out the quickest way to do this without having to go one by one through each record and tagging each grade they are in before import. Truly appreciate any insight or advice you can provide. I'm quite adept at Excel so don't mind doing some pre-clean up work to the sheet before uploading if necessary - just trying to avoid the one record at a time.
... View more