Read details from Global Address Book in Outlook into Excel

[mkvassh]

I use the following code to read information from the Global Address Book in Outlook, and it works. Do any of you know how I can read the Email-address and alias-Name as well? By other word more information from each record. The code below will give me the name only.

Please Login or Register  to view this content.

[romperstomper]

Depends exactly what you want. I assume from your mention of alias that you are talking about an Exchange server? If so, something like this:

Please Login or Register  to view this content.

[mkvassh]

Thanks. What I need is all names, userid and Email in the Global Address Book in the company where I am working. I can view all this and more if I view a contact in Oultook. If I run my macro will it only list names, nothing more. If I run your macro will it stop at the line below and give me run time error 438 "Object doesn't support this property or method. Any idea what I should do?

With myAddressList.AddressEntries(i).GetExchangeUser

[romperstomper]

Sorry - I misread your office version. The ExchangeUser object was added in 2007.

I don't know how to get that sort of data from Outlook (it's not my area), but I would probably bypass it anyway and use ADO with an LDAP query (since I think you are looking at ActiveDirectory properties as much as anything) - something along the lines of :

Please Login or Register  to view this content.

[mkvassh]

Thank you :-)

[cmwhite87]

Hello,

It appears the command you show above would simply pull every address available, correct? Where/How can I supply a variable/cell reference, within that command, to return specific email address data based on the names I have stored in my existing workbook.

[Cutter]

Hello cmwhite87, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[benrobot]

I found romperstomper's post extremely helpful. I found a website that seems to enumerate the available fields if someone wanted to expand romperstomper's SQL query.
http://www.kouti.com/tables/userattributes.htm

Using the information from that website one can change

Please Login or Register  to view this content.

to something like

Please Login or Register  to view this content.

where the title and department for each user will also be copied.