How do I export our address book from Exchange 2010 to a CSV file

Posted on 2011-09-15
Medium Priority
Last Modified: 2012-05-12
We are going to be testing a Faxing program and I need to import portions of our address book to their server via a CSV file.  How do I create the file
Question by:J.R. Sitman
  • 4
  • 3
LVL 49

Accepted Solution

Akhater earned 1200 total points
ID: 36546170
what info you want in it?

something like

Get-Mailbox -ResultSize unlimited | Select-Object name,primarysmtpaddress | Export-Csv c:\list.csv

Author Comment

by:J.R. Sitman
ID: 36546805
yikes.  I need whole groups.  This is too difficult.  Gotta be an easier way???
LVL 10

Assisted Solution

by:Mohammed Rahman
Mohammed Rahman earned 800 total points
ID: 36547006
can we download the entire GAL in outlook (personal address book) and them add them to the contacts and export to excel as CSV.


Download the entire GAL to the MS Access database and then to excel as CSV.... (just an idea, dont know if access databse can be exported to csv)


Check this out :)


Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!


Author Comment

by:J.R. Sitman
ID: 36547208
thanks, I'll review these tomorrow.  Yes Access can be exported to CSV
LVL 49

Expert Comment

ID: 36547691
you really mean this is easier then pasting just one line ?

anyway your decision

Author Comment

by:J.R. Sitman
ID: 36576040
@Akhater, where do I paste it?
LVL 49

Expert Comment

ID: 36578777
Go to your exchange server and run Exchange Management Shell

copy paste the code

Author Closing Comment

by:J.R. Sitman
ID: 36945409

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Disk errors can be the source of sundry problems for the Exchange server, the most common one being that the database fails to mount.
Read this tutorial to learn how to fix repeating password error prompts when setting up Gmail IMAP with Microsoft Outlook. The entire process is described with step by step, illustrated instructions. Enjoy...
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
There may be issues when you are trying to access Outlook or send & receive emails or due to Outlook crash which leads to corrupt or damaged PST file. To eliminate the corruption from your PST file, you need to repair the corrupt Outlook PST file. U…

623 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