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
Thanks!
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.
<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! :)