Here is my situation:
I send many complicated emails from work. I have an Excel macro that generates the emails for me. After checking the email, I then send it manually by clicking send. I want to create a log table in excel that will keep a list of the subject line of the email and the date sent. Since the macro doesn't actually send the email ( I send it manually ) I can't figure out how to have a macro write to the log table when the email is sent.

Since I sometimes will use the macro to generate an email which I then do not send out, I only want the log to be written when the mail is actuall sent (not when the email is created).

This is a great board. Thanks in advance,