title: Display GAL in Excel to get Alias or Email Adress
body: <p>I am trying to make use of information found in <a href="https://stackoverflow.com/questions/12552516/display-the-outlook-gal-in-excel-2010-vba-macro">THIS POST</a>.
  I have 2 issues:</p>
  
  <ol>
  <li><p><strike>the following line hangs indefinitly.</strike> FIXED--- its just hidden and has no task bar item, simple search told me how to bring to to the front
      strAddress = objWordApp.GetAddress(, strCode, False, 1, , , True, True).GetProperty("<a href="http://schemas.microsoft.com/mapi/proptag/0x3A00001E" rel="nofollow noreferrer">http://schemas.microsoft.com/mapi/proptag/0x3A00001E</a>")</p></li>
  <li><p>I need to return something I can use in a TO line, so an ALIAS or a full email address.  I have tested this code in WORD and it works perfrectly (remvoing the references to word) except I cannot get the correct information I need.  When I pull  I get an exchange distinguished name.. I need to convert this somehow to an alias or email address</p></li>
  </ol>
  
  <blockquote>
    <p>/o=corperation/ou=administration/cn=my.name</p>
  </blockquote>
  
  <p>BACKGROUND: the code in the previously mentioned post displayed the OUTLOOK GAL so a user can search/select a contact from it.  I want to use the GAL because it can handle the 200,000+ records and includes distrobution lists.</p>
  
  <p>SOFTWARE: This has to function within the OFffice 2010 suite.  I don't need any backwords compatibility and future proofing is a minimal concern at the moment.</p>
  
  <p>END RESULT: I basically just want a user to be able to search for a recipient and have that address end up in a cell.</p>
  
  <p>Any hints would be greatly appreciated.</p>