title: Pass a variable between Outlook and Excel - was email actually sent
body: <p>Not even sure if this is possible but wanted to ask anyway.
  I have an Excel sub where I create an Outlook e-mail which is then displayed for editing on a user's PC.
  I know how to do all of the coding to mark Excel to show that the e-mail was created but what I don't know is whether the user actually pressed the &quot;Send&quot; button or not.
  Is there any way to pass a TRUE variable back to Excel if the user does indeed press the &quot;Send&quot; button or leave it as False if they do not?</p>