Update status in excel cell for email sent or not sent by user

Guy's, I have created a code in Excel to send mails. What I want to do is, I want to update the status of mail if it is been sent by user or not. When my code draft mail and displays and If user close that mail (or press the close button) by mistake, my excel cell should be updated as “mail not sent” and vice-o-versa. I want to update the status in cell “D1” Please help…! below is my coding.

Thanks in advance...!

Please Login or Register  to view this content.