How can I import all user contacts from outlook into global address list in exchange 2013?

Posted on 2015-01-19
Last Modified: 2015-01-21
I'm working on a project where a client had a catastrophic failure with an on-premise exchange 2007 server. Client had no IT support at the time and there were no backups, no nothing. The exchange 2007 environment effectively no longer exists. I installed a new server with exchange 2013 and set everything up from scratch, importing PST files from outlook to rescue their email and contacts. Since 2007 isn't available, I have no way to move, copy, or import the GAL that was in use. Is there a way to grab all the contacts from each users outlook and import them into the new GAL? Let me rephrase, I'm sure there is a way, but is there a way, short of exporting contacts as a CSV from each outlook installation and then importing them individually via powershell?
Question by:sdholden28
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
  • 3
LVL 43

Expert Comment

ID: 40558287
I don't see any reason for importing contacts from user outlook, as those are not be company related, it might be created by each user for personal use. Secondly, in this case you don't have much option left, just implement email address policy. I might set a auto reply to external vendor about the email address change and also ask user to update their vendors about new email address for future communication.

Author Comment

ID: 40558417
I'm trying to recreate some resemblance of the Global Address Book that was lost. Many of the users have addresses in their outlook contacts that were also in the old Global Address List, so if I can import all of these contacts into the new Global Address Book, I'll be pretty close to what the list was before it was lost.
LVL 43

Accepted Solution

Amit earned 500 total points
ID: 40558513
How many users you are talking here? If count is low, better to do it manually.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 14

Expert Comment

by:Alexei Kuznetsov
ID: 40560041
So, you want to create new AD users from Outlook contacts? Or AD contacts? Because GAL is actually a list of mail-enabled objects (including users, groups, contacts, etc.)

Author Comment

ID: 40562165
This organization had external contacts in a global address book. I.e. all users could open outlook and view the same address book that had all of these contacts in it. That list was lost with exchange 2007 so I'm trying to recreate it best I can, and if I could import all of the contacts that came over when user PST files were imported, then that would help. I may not be using the correct terminology, but that is what I'm trying to do.
LVL 43

Expert Comment

ID: 40562177

Author Comment

ID: 40562693
I ended up importing contacts from CSV files via powershell. CSV file needs to have headers, and can be imported by running the following via management shell:

Import-Csv "C:\Contact-Import.csv" | Foreach-Object { New-MailContact -Name $_."Name" -ExternalEmailAddress $_."E-mail Address" }

There are many other parameters that can be specified, but those two are all I needed.
CSV file should look like this:

Name, E-mail Address
John Smith,
Jane Doe,

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
To show how to generate a certificate request 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 Servers >> Certificates…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

749 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