Solved

Pulling Active Directory user contact info

Posted on 2004-08-23
5
336 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

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!

Question has a verified solution.

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

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…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 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