title: How to send email from secondary email address without setting up a second account?
body: <p>I am using Excel 2010 on W7 x64, to send email from Outlook using code from Ron de Bruin. I have an individual and group email address that I send from.<br />
  I want to send from the group address by changing it in VBA.</p>
  <p>The secondary address is not set up as an actual account in Outlook. If I go to File - Account Settings in Outlook, there is only one email account listed.</p>
  <p>The group email address simply forwards to the group.</p>
  <p>I created an actual account for the group box.<br />
  I added the reference to Microsoft Outlook Object Library in VBA, and added the code to select between account 1 or 2 using the <code>MailItem.SendUsingAccount</code> property, but Outlook would freeze up when trying to send from this address.</p>
  <p>I can manually select between my Individual and Group email in the from dropdown box in Outlook when I send emails.<br />
  Is there a way to do this in VBA without setting up a second account?</p>