Alert prompt if date and time is reached

Hi. Yes this is very close. In the subject of the email, it will be Ai and not always A2. So if row E meets the criteria the email subject would be whatever is in cell E2 and 'needs looking at'.

Also, would it be possible to put a check in place that makes sure outlook is open,and if it is not, open it for the user automatically? And the last thing would be that if the email was sent for say row 2, then in cell F2, it would enter the word SENT. And then when the macro is run again, if the criteria are met but the word SENT is in the row then the email will not send for that row.