import a .csv file of external addresses into a separate address list

Posted on 2008-02-05
Medium Priority
Last Modified: 2008-03-06
I have a .csv file of all our customers.  I would like to create an address list in exchange (not in Global) with just these addresses so everyone (with security) can access if needed.  and I could easily update the csv file and repopulate it with new information.  Thanks  Dean
Question by:deanquaker
  • 2
  • 2
LVL 15

Expert Comment

ID: 20825897
You can import a CSV directly in to a public folder using outlook, where you can use this for an address book, and also set access rights.

Hope this helps :)
LVL 10

Expert Comment

ID: 20826134
You can use this :
for help with how to use CSV

You can also create an additional Address list via ESM.

Go to Recipients
All Address Lists
Right Click and chose NEW --> Address List.
This List will show up (with the GAL) when people click on their address book

Author Comment

ID: 20826245
Thanks for the quick response.   So once the address list is created and is seen in Outlook, can I take a CSV file and populate that address list with emails?  I don't see anywhere that I can do that.  Thanks
LVL 10

Expert Comment

ID: 20826622
First you want to populate the AD with the users / contacts using the CSV file.  It should have all the attributes you want in the CSV file.

You then create the address list in ESM later.


Accepted Solution

deanquaker earned 0 total points
ID: 20827093
So in order to get these external email addresses in an 'address list' in exchange, I have to first add them as users in AD and then create the address list in ESM.  Then use the filter to put those users into the created address list.  Is that correct?

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

Question has a verified solution.

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

You finally migrated Public Folders to Office 365, decommissioned the Public Folder mailbox database and since then, when you send an email from on-premise to mail-enabled Public Folders, you get the following error: "Misconfigured public folder mai…
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Suggested Courses

598 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