Solved

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

Posted on 2011-09-15
8
616 Views
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
0
Comment
Question by:jrsitman
  • 4
  • 3
8 Comments
 
LVL 49

Accepted Solution

by:
Akhater earned 300 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
0
 

Author Comment

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

Assisted Solution

by:Mohammed Rahman
Mohammed Rahman earned 200 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.

OR

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)

http://www.howtogeek.com/howto/database/access/export-exchange-global-address-list-to-access/

Check this out :)

http://community.spiceworks.com/how_to/show/1288

0
 

Author Comment

by:jrsitman
ID: 36547208
thanks, I'll review these tomorrow.  Yes Access can be exported to CSV
0
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

 
LVL 49

Expert Comment

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

anyway your decision
0
 

Author Comment

by:jrsitman
ID: 36576040
@Akhater, where do I paste it?
0
 
LVL 49

Expert Comment

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

copy paste the code
0
 

Author Closing Comment

by:jrsitman
ID: 36945409
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create a User Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Mailb…
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…

747 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

12 Experts available now in Live!

Get 1:1 Help Now