Solved

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

Posted on 2011-09-15
8
762 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:J.R. Sitman
  • 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:J.R. Sitman
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

Author Comment

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

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
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…
This video discusses moving either the default database or any database to a new volume.

733 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