Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

Mass import of SMTP addresses into DL

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
jgibbon
Asked:
jgibbon
1 Solution
 
rezzerCommented:
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
 
jgibbonAuthor Commented:
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
 
jgibbonAuthor Commented:
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.

 
beacomCommented:
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
 
bruintjeCommented:
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
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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