Excel Lookup to Exchange Global Address List

[Notnorml]

I have a list of user names in Column A and I would like a VBA process
to look up that name via Outlook in our corporate mail server and
return the SMTP address assigned to that user.

I have no idea how that would be accomplished.

Any help and points in the right direction would be helpful.

Thanks