How can I easily extract all email addresses set up in AD into a txt or csv file?

Posted on 2008-11-05
Last Modified: 2012-05-05
How can I easily extract all email addresses set up in AD into a txt or csv file?
Question by:TED_UBB
    LVL 13

    Expert Comment

    Go to view, and add/remove columns and add the correct columns to AD users and Computers.  YOu can then right click the correct OU, or the domain, and export list... and put it either tab delimited, or comman delimited.
    LVL 31

    Accepted Solution

    Hi TED_UBB,

    csvde -f emails.csv -r (objectclass=user) -l "name,mail"



    Author Closing Comment

    Many thanks for your speedy & accurate assistance!

    Author Comment

    Sorry Brum07, but Toniur's answer was the quicker to execute!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    My last post dealt with using group policy preferences to set file associations, a very handy usage for a GPP. Today I am going to share another cool GPP trick, this may be a specific scenario but I run into these situations frequently in my activit…
    Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now