Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bulk Insert Mail Contacts into Exchange 2007 and not active directory

Status
Not open for further replies.

asotmhg

Programmer
May 11, 2000
48
US
I am running an Exchange 2007 server. I want to import a few hundred customer contacts into the global address list and create groups usng those email addresses. I am then going to add the exchange address list to the users pop accounts, so they have a separate address book for customers. I am reading where people are creating mail enabled contacts in AD. I am not sure that this is what I am needing to do. My understanding is that mail enabled contacts have access to network resources, but have external email addresses. I don't want the contacts I import to have an AD entry or access to the network. I simply want them available in the global address book, so their email addresses are more easily accessible. How do I need to do that?
 
Any contact you create will be created in AD, but they won't be user accounts in AD with actual logons or access to the network. I would choose a particular OU to put the new contacts in before you proceed with the creation process.

For bulk contact creation, I'd use PowerShell, and would follow this method:

Once the contacts exist in a particular OU, it will be relatively easy to assign them all to a distinct address book.

Dave Shackelford
ThirdTier.net
TrainSignal.com
 
Thank you. I found out how to do that. I put these as column headers in an excel spreadsheet:

DN
objectClass
distinguishedName name
objectCategory
cn
displayName
mail
sn
givenName

Then I put the corresponding information in each column for each contact. These contacts will be mail enabled and in its own Organizational Unit (OU) which I called Customers.

CN=Contacts Name,OU=Customers,DC=Mydomain,DC=com
contact
CN=Contacts Name,OU=Customers,DC=Mydomain,DC=com
Contacts Name
CN=Person,CN=Schema,CN=Configuration,DC=mitchellgrocery,DC=com
Contacts Name
Contacts Name
Contacts Email Address
Contacts Last Name
Contacts First Name

Then I saved it as a comma delimited file (.csv) and moved it over to the Active Directory server. I opened up a command prompt by right clicking on the command prompt and selecting 'Run as Administrator'. I then used csvde at the command prompt to import the file.

csvde -i -f Full Path to the csv file The import worked fine and the contact showed up in Active Directory (AD) and Exchange as a mail enabled contact.

I am now trying to figure out how to show them in a separate Address book from the rest of the domain users in AD.

 
Hi

Dovestone software tools are great for doing this type of work. You create and customise the spreadsheet CSV file then import and the software takes care of the rest for you

Regards
Andy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top