Join data to Direct Mail | Parent and child table

Question

I have a spreadsheet with data of students. For each discipline of the same student there is a specific line. I would like to do a direct mail with only one email per student, but that imports the data of all subjects.

Table: First column has the student ID, each student has his or her own. Second and third names and surnames respectively. Fourth and Fifth Column ID and Subject Name, and finally on Sixth and Seventh onwards the student’s performance in each subject.

Example:

ID......... Name and Sobr...... ID and name matter...... Access...... Note 1.. N2.. N3.. N4
1234 ..... João Silva............ 3
English.........28/04..................... ...2...... 5.... 4

How do I get all the disciplines of a student to come to a page? Example above, more Mathematics, Sciences, Reasoning, etc

Answer 1

You have in your table:

ID      Nome e Sobr ID e nome matéria   Acesso  Nota 1  n2  n3  n4
1234    João Silva      3 Português     28/04   1       2   5   4
1234    João Silva      4 Matemática    28/04   1       2   5   4
1234    João Silva      5 História      28/04   1       2   5   4

7890    Maria Oliveira  3 Português     26/04   1       2   5   4
7890    Maria Oliveira  4 Matemática    26/04   1       2   5   4
7890    Maria Oliveira  5 História      26/04   1       2   5   4

You have a single table that has all this information and you want to group it by student, subject containing the information that is in this correct format?

So start by organizing the data if the order is not according to what you want to send in the email.

By the way, where’s the e-mail address?

I suppose it’s in the same file, as follows.

ID      Nome e Sobr     ID e nome matéria   Acesso  Nota 1  n2  n3  n4  email
1234    João Silva      3 Português         28/04   2       5   4   4   [email protected]
1234    João Silva      4 Matemática        28/04   1       2   5   4   [email protected]
1234    João Silva      5 História          28/04   1       2   5   4   [email protected]

7890    Maria Oliveira  3 Português         26/04   1       2   5   4   [email protected]
7890    Maria Oliveira  4 Matemática        26/04   1       2   5   4   [email protected]
7890    Maria Oliveira  5 História          26/04   1       2   5   4   [email protected]

Organized the spreadsheet, I don’t know how you will create the email, but possibly a macro where through a loop (while, repeat), read the email and while the email is no different assembles the email with the information, when the email is different send the email and restart the process to the next, so until the end of the file.

By the way, as you are using spreadsheet, at the time you send the email, save in the last column the information that sent the email, so you will not send it again.