Solved

Importing contact lists from Active Directory

Posted on 2009-07-15
10
487 Views
Last Modified: 2013-11-05
I would like to populate MS Outlook contact lists (name, email, some other fields) using the information contained in Active Directory maintained for a MS Server domain and kept on a Server 2003 R2 box.  Is there any simple way to do this or any 3rd party programs with simple GUI interfaces that let you do this?  I don't want to get involved in programming to do this.  This seems like something that would be commonly done to populate Outlook contact lists.
0
Comment
Question by:dakota5
  • 5
  • 5
10 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 24872844
Hi, dakota5.

You can do it all using Outlook's native GUI.  Are you saying you don't want to do that?  If so, why?
0
 

Author Comment

by:dakota5
ID: 24875560
Great!  I searched Outlook help and did a quick Google search and did not see this.
I've opened file | import and export and don't see anything about Active Directory on the list of options from which to import contacts.

Please give me the specifics--- how does an administrator on a domain import information from Active Directory into a local MS Outlook contact list.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24876728
First, let me make sure we're both talking about the same thing.  I'm talking about creating a contact list with members from Active Directory/Exchange.  Contact lists only contain an email address and I notice that you mention "name, email, some other fields".  So, are we talking about a list or individual contacts?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:dakota5
ID: 24882647
If you look at the properties of a domain user in Active Directory, there are 13 tabs, each with several fields.  All of the data is accessible programatically.
Some of the tabs (General, Address, Telephones, Organization) have information that could be used to populate a contact list in MS Outlook.
I'm assuming that Outlook has a method for accessing this data from Active Directory to populate a contact list.
If not, I would expect there is a third party solution to do this.
Exchange Server is not involved-- we don't use it.

So I'm speaking about querying Active Directory (with an easy to use GUI) to populate a list of contacts (with a variety of addess, phone number and email info) in MS Outlook
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24883537
I need to know what you mean by "list of contacts".  As I noted above a true contact list can only store the email address of each member.  It can't store any other properties.  
0
 

Author Comment

by:dakota5
ID: 24884320
In Outlook you create folders that contain multiple contacts.  Each contact in the list has many fields and is a common way of organizing contact information (email, phone numbers, addresses) and the list of contacts in a group has selectable fields for display.
There is a large overlap in the information contained in the contact lists in Outlook and in Active Directory.

I know that CSVDE and LDIFDE are command line programs that can export information from Active Directory.  I was looking for a GUI based way of accessing the data from Outlook.

I should probably withdraw this question and resubmit it to the Active Directory section.
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24885916
Got it.  My confusion was over the use of the word "list".  Now I understand how you mean it.

You can create a contact from an entry in AD directly form Outlook via these steps.

1.  Click the Address Book icon on the Outlook toolbar.
2.  Find the AD entry you want to import.
3.  Double-click the entry and select Properties
4.  When the properties appear click the "Add to Contacts" button in the lower left-hand corner.

This copies the contact from AD to Outlook.  
0
 

Author Comment

by:dakota5
ID: 24886408
OK.  Sorry about not being clearer.
When I click the address book icon in the Outlook toolbar,  I see only the existing entries in the local Outlook contact list.
There are no entries from Active Directory.  I'm doing this on a client workstation in a Server 2003 Domain (no MS Exchange server;  we use an external email system).
I don't know how to get Outlook to see the information held in Active Directory on the server.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 250 total points
ID: 24886509
Well, that's different.  This only works if you have an Exchange server.  The alternative is to do this via some scripting.  Do you have a list of fields that you want to import each time?
0
 

Author Comment

by:dakota5
ID: 24887170
Yes I do.
last name, first name, description, email, user login name,
title (from organization tab) , department.

Is there a way to create dynamic user info tables (MS Access or Excel) with the above fields, based on queries against an AD service? (like you could if AD were a standard database.)

If not, is there a way to get Server 2003 (not Exchange Server) to run an ldap service and point Outlook to search for contacts against that?

If there is no way to query against AD, then I'll have to go with scripting.  If you can help me through either (either dynamic queries if possible or static scripting if dynamic is not possible), I'd be happy to increase the point value to 500.  This seems like a lot of effort on your part.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook Free & Paid Tools
Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question