?
Solved

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

Posted on 2011-09-15
8
Medium Priority
?
889 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
[X]
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
  • 4
  • 3
8 Comments
 
LVL 49

Accepted Solution

by:
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
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 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.

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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
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…
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…
Suggested Courses
Course of the Month15 days, 3 hours left to enroll

771 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