Solved

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

Posted on 2015-01-19
7
335 Views
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?
0
Comment
Question by:sdholden28
  • 3
  • 3
7 Comments
 
LVL 41

Expert Comment

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

Author Comment

by:sdholden28
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.
0
 
LVL 41

Accepted Solution

by:
Amit earned 500 total points
ID: 40558513
How many users you are talking here? If count is low, better to do it manually.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 13

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.)
0
 

Author Comment

by:sdholden28
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.
0
 
LVL 41

Expert Comment

by:Amit
ID: 40562177
0
 

Author Comment

by:sdholden28
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, johnsmith@johnsmith.com
Jane Doe, janedoe@janedoe.com
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
Read this checklist to learn more about the 15 things you should never include in an email signature.
In this video we show how to create an Address List 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 Organization >> Ad…
how to add IIS SMTP to handle application/Scanner relays into office 365.

911 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

16 Experts available now in Live!

Get 1:1 Help Now