Solved

Importing contact lists from Active Directory

Posted on 2009-07-15
10
484 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
 

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Find out how to use dynamic social media in email signatures with this top 10 DOs & DON’Ts.
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now