How can i get a list of email addresses out of exchange?

Posted on 2007-11-20
Last Modified: 2010-07-07

i have exchange setup under sbs 2003.  i have about 60 users.  is there an easy way of extract the exact login name and email address(es) for each user without having to go into each one individually?  The addressing scheme does not appear to follow any pattern!
Question by:gerpaqit
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +3
LVL 12

Expert Comment

ID: 20322903
dont have much experiance with sbs but if you have active directory you can use tools

LVL 29

Expert Comment

by:Michael Worsham
ID: 20322950
LVL 13

Expert Comment

ID: 20322993
what you do is go to active directory.  click on your domain and go to find.

when the box opens, go to "Find:" and select Exchange Recipients

Under the General Tab select "Users with Exchange mailbox"

Uncheck the rest

Now click Find Now
Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

LVL 12

Expert Comment

ID: 20322999
nice script
LVL 13

Expert Comment

ID: 20323015
what i posted just shows u the Name, Alias and Email Address.  It doesn't export them anywhere

Author Comment

ID: 20323126
cshepfam solution is best so far!!!....shows everything i need....just one thing....i need to get this into word/excel...any ideas...i need to manipulate is slightly so a screen grab wont work...
LVL 13

Assisted Solution

cshepfam earned 200 total points
ID: 20323317
alright, i'm trying to create a script for you.  so far i got it where you can export it to a text file, the name and the email addresses, but not the login name.  i'll work on that.

but this is what you need to do:

1. Start > Run > cmd

type this in precisely:

dsquery * -filter "(&(objectCategory=person)(objectClass=user)(mail=*))" -attr mail displayname -limit 0 > c:\emailaddresses.txt

then go to your C: and look for that text file
LVL 22

Expert Comment

ID: 20323318
i wrote a script a while back that does this. check it out here:

LVL 74

Accepted Solution

Jeffrey Kane - TechSoEasy earned 300 total points
ID: 20323773
Just go to the SBS Server Management Console > Users Snap-in

Then from the main menu choose > Action > Export List and save it as a .csv file.

It doesn't get any easier than that!


Author Closing Comment

ID: 31410214
thanks to everyone!....

Featured Post

Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CAL for Disabled accounts 4 55
Change Exchange sync schedule on Samsung Galaxy S8 1 55
Hybrid Exchange 6 22
Exchange 2016 CU5 10 27
Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Utilizing an array to gracefully append to a list of EmailAddresses
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
how to add IIS SMTP to handle application/Scanner relays into office 365.

739 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