Hi

this is my first thread in the forum
I am trying to build an excel sheet to track reports
the columns will be
Date report requested//who need to make the report(reporter)// reporter email// send email for the reporter

in the send email only three values are there
Send email1 "send email in the first 24 hour"
Send email2 "send reminder email after 48 hours"
Send email3 "send reminder email after 72 hour"

I need once I select "Send email1" to automatically open the outlook with the email of the reporter with htmlbody of table containing the report name, deadline, reason for the report

I tried different codes but eather they work with any change in the sheet or they are not wroking

Received Date Send Emails
27/05/19 08:03:15 PM Send Email1
27/05/19 08:04:44 PM Send Email2
28/05/19 10:16:59 AM Send Email3


the other challenge for me is that the code was sending to the email in the first row even I didn't change any thing in it


for your help please