When you send the mail you will get a mail ID returned and it will be stored in MSDB, simply store that mail ID in a table along with the status, and then have some automated process like a SQL job which checks the table for any unsent mails, query msdb, find the new status then update the table.