Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Mass import of SMTP addresses into DL

Posted on 2001-08-15
6
Medium Priority
?
315 Views
Last Modified: 2011-09-20
We have a requirement to import a list of SMTP e-mail addresses (currently in a text file)into an Exchange 5.5 Distribution List. We know it is possible to do this on a individual basis by creating a Custom Recepient for each address but for 500 addresses this could prove to be a little overwhelming. Any thoughts on this?
0
Comment
Question by:jgibbon
6 Comments
 
LVL 1

Expert Comment

by:rezzer
ID: 6391733
You need to create a .csv(comma seperated  file which takes the following form
obj-class, first name, last name, e-mail address
remote, joe, bloggs, smtp:joebloggs@acme.com
remote, john, doe, smtp:johndoe@acme.com

this can be created easily with excel if it is not already in this form(remote designates a custom recipient).
Then you need to do a directory import using Exchange Admin -> Tools -> Directory Import. Select your .csv as the import file and the container you want to import to and hit the IMPORT button
0
 

Author Comment

by:jgibbon
ID: 6393598
Thanks Rezzer. I am aware of this process. Unfortunately, we were only provided a list of e-mail addresses and not the details on the people or groups related to them. We are doing this as a courtesy for an annual charity fund raiser so it will be rarely used. It's starting to sound like the CSV import is the only option. I'll wait a few days to see if any other ideas pop up before committing the time to buld the CSV file.
0
 

Author Comment

by:jgibbon
ID: 6393872
Thanks Rezzer. I am aware of this process. Unfortunately, we were only provided a list of e-mail addresses and not the details on the people or groups related to them. We are doing this as a courtesy for an annual charity fund raiser so it will be rarely used. It's starting to sound like the CSV import is the only option. I'll wait a few days to see if any other ideas pop up before committing the time to buld the CSV file.
0
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.

 

Accepted Solution

by:
beacom earned 400 total points
ID: 6455383
Use the cvsde utility
You can export a sample user from 2000 as follows

csvde -f sample.csv -s server1 -d "CN=Ron Beacom,CN=Users,DC=genesysnet,DC=com

The above will export a user named "Ron Beacom" from the Users in a 2000 domain called genesysnet.com off of server1 to a file called sample.csv

You can then open this file up with Excel and eliminate the columns you don't want and then fill in the rest with the 500 users you want to import

Then run the following to import them into Active Directory

csvde -i -f sample.csv -s server1

The following is an example of the header required to do this in Excel

DN,cn,displayName,mail,givenName,objectClass,proxyAddresses,name,sAMAccountName,userAccountControl,userPrincipalName,msExchHomeServerName,mailNickname

Reference page 437 MCSE Training Kit Microsoft Exchange 2000 (Microsoft Press)

This is a good book. Sybex sucks for Exchange 2000 (usually they are pretty good!)
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7270488
Hello jgibbon

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-PAQ
-points to beacom
-this will be finalized by an EE Moderator
-with no further update (15.09.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0
0
 

Expert Comment

by:Jgould
ID: 7297229
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
How to effectively resolve the number one email related issue received by helpdesks.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

916 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