Join data for Mail Merge | Parent and child table

6

I have a spreadsheet with student data. For each subject of the same student there is a specific line. I would like to do a mail merge with just one email per student, but I would import the data from all the articles.

Table: First column has the student ID, each student has his / her own. Second and third name and last name respectively. Fourth and Fifth Column ID and name of Matter, and finally in the sixth and seventh onwards the performance of the student in each subject.

Example:

  

ID ....... Name and Name .......... ID and name matter ...... Access ...... Note 1..n2..n3..n4 >   1234 ..... João Silva ............. 3
  Portuguese ............ 28/04 ........... 1 ......... 2 .... 5 .... 4

How do I get all of a student's subjects on a page? Example above, plus Mathematics, Science, Reasoning, etc.

    
asked by anonymous 28.04.2015 / 19:47

1 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 them by student, which contains the information that is in this correct format?

Then start by organizing the data if the order does not match what you want to send in the email.

About where is the email 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 do not know how to create the email, but possibly a macro where through a loop ( while , repeat ), read the email and while the email is not different mounts the email with the information , when the email is different it sends the email and restarts the process for the next one, until the end of the file.

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

    
29.04.2015 / 20:15