Solved

Importing contact lists from Active Directory

Posted on 2009-07-15
10
489 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

636 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