Macro Email Return Value

[southcali12]

Hi All,

I send out emails via a macro. All of the emails' information are found in the workbook. What I would like to do next is once an email is sent out, is there a way to return a value to column L? It would simply be something to just let me know that the email was actually sent out, and if it isn't sent out for a value in column L to populate with something like: "Message did not send". Thanks!

 

[southcali12]

Whoops, I should mention that I am using Outlook.