Solved

Mass import of SMTP addresses into DL

Posted on 2001-08-15
6
302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Accepted Solution

by:
beacom earned 100 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In-place Upgrading Dirsync to Azure AD Connect
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…
Suggested Courses

632 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