Solved

Pulling Active Directory user contact info

Posted on 2004-08-23
5
335 Views
Last Modified: 2010-04-19
My company currently has 2 or three small contact lists for our internal employees which is inefficient since sometimes they're not updated.  Since I just upgraded to Win2003 & Exch 2003 I was hoping to leverage the contact information built into each user listed in AD in order to centralize our internal corporate contacts.  

I know that this user info (i.e. phone, address, email, etc.) can be viewed in the Global address book, but I was wondering the following:

1) Can the AD user info be merged directly to a Word template? (Our current contact list is distributed as a word Doc via email)
2) If not, can the AD user info can be published or dumped to a Public folder in Outlook, where we would then be able to perform a mail merge into Word.
3) Or, could we dump the data to a CSV file.

Any help would be greatly appreciated.

Thanks,
Rob
0
Comment
Question by:rimmella
  • 2
5 Comments
 
LVL 104

Accepted Solution

by:
Sembee earned 125 total points
ID: 11874435
You cannot merge directly from the GAL, the GAL content needs to be in either a public folder marked as an Outlook Address book or dumped out to a CSV file.

A good place to start wout be here: http://www.slipstick.com/exs/portagal.htm 
There are a couple of options that could do what you need them to.

Simon.
0
 
LVL 9

Expert Comment

by:SamuraiCrow
ID: 11874476
I don't know of a way to merge it directly into a word template but if you are using 2003 you can run DSQuery from the command line and get all sorts of good info.  For instance if I want to view all contacts and have it output to a list I can type the following

DSQuery contact -limit 10000 > c:\contacts.txt

the limit switch just tells me how many results I can store (only a hundred without the switch).  Take a look at the output and let me know if this might be along the lines of what your are looking for.  

Crow
0
 
LVL 9

Assisted Solution

by:SamuraiCrow
SamuraiCrow earned 125 total points
ID: 11874676
I just found this great link that goes into a little more detail on the process I was describing:

http://www.jsiinc.com/SUBP/tip7900/rh7993.htm

Good Luck
Crow
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 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