Outlook-GAL-info.xlsm

<div>
Thank you! I will check this out when I am not on the road... :)
</div>


Thank you! I will check this out when I am not on the road... :)

<div>
Hi Ejgil,<br />
<br />
this error was thrown: ActiveX component can't create object or return reference to this object (Error 429) <br />
<br />
at this line: Set objSession = CreateObject(&quot;MAPI.Session<wbr />&quot;)<br />
<br />
I use Outlook and am not sure why the MAPI class isn't registered
</div>


Hi Ejgil,

this error was thrown: ActiveX component can't create object or return reference to this object (Error 429)

at this line: Set objSession = CreateObject("MAPI.Session")

I use Outlook and am not sure why the MAPI class isn't registered

<div>
Could be related to the Microsoft December 2014 update, disconnecting ActiveX controls.<br />
I haven't tried it, but some refer to this MS Fix it, so try that.<br />
<a href="https://support.microsoft.com/en-us/kb/3025036/en-us" rel="ugc">https://support.microsoft.<wbr />com/en-us/<wbr />kb/3025036<wbr />/en-us</a>
</div>


Could be related to the Microsoft December 2014 update, disconnecting ActiveX controls.
I haven't tried it, but some refer to this MS Fix it, so try that.
https://support.microsoft.com/en-us/kb/3025036/en-us [https://support.microsoft.com/en-us/kb/3025036/en-us]

<div>
<div class="content wysiwyg-content">
Greetings,<br />
<br />
I have a column in which I am entering names of people, one per cell. Is there a way to have the cell resolve the name to an emaill address where the result is the user name as it appears in the GAL?<br />
<br />
Thank you!<br />
JohnD
</div>
</div>


Greetings,

I have a column in which I am entering names of people, one per cell. Is there a way to have the cell resolve the name to an emaill address where the result is the user name as it appears in the GAL?

Thank you!
JohnD

Excel lookup (using Outlook config) to resolve name to internal email address

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.