So occasionally i will get an email that lists trainings people have missed and I need to email each person listing the trainings they need to take care of.
The email is in a table form like below, basically Column A is name Column B is missed trainings and Column C is how late the trainings are.
However if they are missing multiple trainings then the name is blank for the extras, Example
| John Doe | Training 1 | 3 |
| John Smith | Training 1 | 3 |
| | Training 2 | 10 |
| | Training 3 | 5 |
| Jane Doe | Training 2 | 10 |
So What i would like to do is make a dynamic email that will send each person an email and list all the trainings they are missing, however many, But I am not sure how to do with without sending multiple separate emails to the same person.
"Hello John Smith
I just wanted to write you because you are missing the following trainings:
Training one 3 days late
Training two 10 days late
Training three 5 days late.
Please take care of these as soon as possible."
But of course if they are only missing one it lists which one they are missing.
