launching email hyperlinks data

[lolly150]

I’m hoping there is a way to make my process of emailing staff much easier

I have a spreadsheet which calculates and then displays a list of staff who are out of date with training and the specific training required (result below).

I have their email address set as hyperlinks and wondered if there was a formula that will look down a column for a staff name (A column) and if so launch the hyperlink (D column) into an email reminding them along with the training required (column C)? I have the text for the email in a separate sheet.

A	B	C	D
Staff Member	Line Manager	Course	Email
Bruce Amanda	Debbie Jackson	Course 1	Amanda.bruce@email
Bruce Amanda	Debbie Jackson	Course 2	Amanda.bruce@email
Anderson Jemima	Sonia Carter	Course 3	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 4	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 1	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 5	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 6	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 7	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 8	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 2	Jemima.anderson@email
Anderson Jemima	Sonia Carter	Course 9	Jemima.anderson@email
Berry Grace	Fred Brown	Course 3	Grace.berry@email
Berry Grace	Fred Brown	Course 10	Grace.berry@email
Berry Grace	Fred Brown	Course 11	Grace.berry@email
Berry Grace	Fred Brown	Course 7	Grace.berry@email
Berry Grace	Fred Brown	Course 8	Grace.berry@email
Bronski Laura	Maxine Trott	Course 12	Laura.bronski@email
Bronski Laura	Maxine Trott	Course 10	Laura.bronski@email
Bronski Laura	Maxine Trott	Course 11	Laura.bronski@email
Bronski Laura	Maxine Trott	Course 7	Laura.bronski@email
Buck Samantha	Debbie Jackson	Course 5	Samantha.buck@email
Buck Samantha	Debbie Jackson	Course 2	Samantha.buck@email

<tbody>
</tbody>

Thanks in advance