Sending email from excel based on cell value

[essasmj]

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

[TABLE="class: grid, width: 266"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Received Date[/TD]
[TD]Send Emails[/TD]
[/TR]
[TR]
[TD]27/05/19 08:03:15 PM[/TD]
[TD]Send Email1[/TD]
[/TR]
[TR]
[TD]27/05/19 08:04:44 PM[/TD]
[TD]Send Email2[/TD]
[/TR]
[TR]
[TD]28/05/19 10:16:59 AM[/TD]
[TD]Send Email3[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Macropod]

Cross-posted at: http://www.vbaexpress.com/forum/search.php?searchid=309476
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[essasmj]

Cross-posted at: http://www.vbaexpress.com/forum/search.php?searchid=309476
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

I tried to delete it but I couldn't

 

[Macropod]

Kindly read the cross-posting rules on both forums. Neither says anything about you deleting a thread.