title: SMTP Outlook Address via VBA
body: <p>I am trying to retrieve the SMTP Address via VBA for a set of emails in Outlook 2007.
  I require the the full SMTP address from the sender. Mainly the address is from an EXCHANGE 2007 server.</p>
  
  <p>I have the smtp address test@something.co.uk; test1@something.co.uk; test3@somthing.co.uk in another table which looks the email addresses to another field.</p>
  
  <p>I need to use the SMTP address from the email to perform a lookup to the field.</p>
  
  <p>When performing the storename = mItem.SenderEmailAddress I get an x400 address, but I need the SMTP address. Surely there is a way of etting this. I don't want to use redemption. I hope someone can provide an answer for this.</p>
  
  <p>Thanks
  H</p>