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.