[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Import External Addresses in to GAL

good day
   i want to import contacts with their external email address to Exchange GAL, i know i have to import them in to active directory and then i create a new address list in Exchange system manager so it can be found in outlook address book drop down list.
what i need to know is how the format of the CSV file since when i do export in active directory i have account name and email address, not like this format ( cn=MailDisabledContact,OU=OU name,DC=Domainname,DC=com) how i can convert it to this format and what the attribute for the email address.
  • 2
3 Solutions
Farhan KaziSystems EngineerCommented:
Greetings MFSabah,
How do you export these items? Use CSVDE.exe to export objects from AD.

For more information / example:

Hope this help!
there are a number of tools you can use to get data into the required format - some people swear by using the mailmerge facility in Word, you can also use scripts - there is an example here http://www.msexchange.org/tutorials/Creating_a_list_of_Users_and_their_email_addresses_in_Exchange_2000.html
opps thats export:
hear is an example of how to import from XL  - http://www.computerperformance.co.uk/Logon/Logon_CSVDE_import.htm
and there is a step-by-step guide to importing - including scripting at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/directory/activedirectory/stepbystep/adbulk.mspx
Before you do this import, are you sure that you want to?
In my experience users don't take kindly to a massive number of contacts they don't care about appearing in the GAL.
Every time I have been asked to do this, I have been asked to remove it within 48 hours.
Most users are not interested in those external contacts - they will be of use to a small number of users.
You then have the issue on how to keep those contacts up to date.
Your better option would be to import those contacts in to a public folder and give access to the folder to those that need it. It is easy for you to give someone permissions to the folder to maintain those contacts as well.


Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now