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
<colgroup><col><col></colgroup><tbody>
</tbody>
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
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 |
<colgroup><col><col></colgroup><tbody>
</tbody>
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
