Picking up multiple cells for email

[AndreaWorkPlace]

HI All. I have written code that picks up all dates in 30 days time where I need to send an email to a specific person telling them that a particular certificate has expired for a particular employee. In the email I would like to pick it up so that it says in the email. " Hello" The SuperHero Accreditation expiry for Iron man is due on 22/03/2022 ( Hey even superheroes need reminding sometime). In this case from my example it would be picking up cells A4 (name), E1 (type of certification) and E4(actual date) I would like to do this across multiple columns as well ie D to F in this case but in reality across a larger range . Is there an easy way to do this. ( VBA for picking up dates, picking up email and sending to relevant person all in place. Its just the content of the email I am concerned about although I have only written VBA for one column not multiple.) Many thanks in advance. Apologies it wont let me upload anything today so best I can do is this! Apologies

Name	ID number	Asbestos Awareness expiry	Driving Licence check	Superhero accreditation expiry
Spiderman	1​	22/03/2022​	22/03/2022​	28/09/2023​
Thor	2​	22/03/2022​	14/09/2022​	22/03/2022​
Iron man	3​	14/07/2022​	22/03/2022​	22/03/2022​
Captain America	4​	16/08/2022​	16/08/2022​	12/06/2024​
Captain Marvel	5​	22/03/2022​	22/03/2022​	22/03/2022​
Black Widow	6​	14/07/2022​	22/09/2022​	26/04/2019​