How do I export to CSV all the SMTP addresses for AD users and groups?

Report email addresses from Active Directory group membership

1. Open Active Directory Exporter and load an AD snapshot

2. Select the Default Report and click on Load Report to load the report.

3. Click Continue to display the report

4. Click the Filters button

Active Directory reporting based on filters

5. Tick both the boxes for Users and Groups options and click Apply and Run or Back

Active Directory reporting advanced options

6. Click the Advanced button for the Advanced Export Options

7. Tick the SMTP Addresses value so that all the values of the special ‘SMTP Addresses’ attribute will be listed when you export the report

8. Click Apply Changes

9. Now when you Export to any of the available formats there will be a new column added called SMTP Addresses with all the SMTP addresses for all the Users and Groups in your Active Directory domain

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.