VBA Changing email content on automatically sent emails

[GhostWatch]

I have a list of 40 conditions that 5 people need to meet. Each person needs to meet the individual conditions at a different time. I have already set up a VBA that sends a generic email to myself as a reminder. Is there a way to automatically change the content and who it is sent to?
I have already got their emails in the sheet.
I have included a basic overview of what the sheet looks like.
I would like it to vary the person, condition and folder that are included in the email.