I am struggling in this matter. I think, there should be an easy way to create a Word or Excel Document, dynamically populating it with data from Active Directory? If I go to Data - new query - from Active Directory, it is rather complicated (and not working in my case)

Example: I want to make a simple overview of Users with Email and Telephone Number, so the users can print the Word document as their telephone list. Upon opening it should fetch the latest data. then it can be saved as PDF end distributed.

If I just make a powershell Query, I have this list in a simple query, but I cannot save it as formatted Word document...

Ist there a simpler approach (built-in, without 3rd party tools except Microsoft Office)?

Edit: I now try getting the data via power query via this guide: https://4sysops.com/archives/excel-get-transform-extract-information-from-active-directory/

It seems the best approach for me till now


Update 2: With the mentioned link I managed to accomplish what I had in mind: Direct retrieval of data from AD with auto-update function in a good output.

  • Use your powershell query and pipe it to: <query> | select object <stuff_you_want> | export-csv -path c:\temp\mydata.csv. Then you should be able to use the suggestion below to do a mail merge into word. This page shows it being done with AD users but the concept should be the same. @CharlesKenyon has the same thing that I would have added at the end and don't want to steal his points! :) – Señor CMasMas May 16 at 18:08

I would simply do a directory or catalog mail merge within Word and keep the data in an Excel spreadsheet.

Here is an excellent tutorial on using such mail merge tools: Catalogue/Directory Mail Merge Tutorial by Paul Edstein, Word MVP

See also his Mailmerge Tips and Tricks and this Microsoft Help Page. Here is a Microsoft Training Video.

Here is my more general page on Word Mail Merge.

  • Thank you - and how do I get the Data into the Excel spreadsheet? If I have to do that manually, I can also just keep the Excel document and export it. – David May 16 at 18:20
  • Where is the data, now? – Charles Kenyon May 16 at 19:02
  • In Active Directory, like mentioned in the subject and text – David May 16 at 19:21
  • See prior comment by Senor CMasMas. You can do a mail merge with as csv file or import that into Excel. – Charles Kenyon May 17 at 1:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.