Bulk addition of new SMTP addresses

We have a large number of distributed sites running various flavours of Exchange from V5.0 up to Exchange 2003. Each of these Exchange boxes hosts a number of mailboxes. We have a requirement to add a new Internet mail address to every mailbox and to make this new address the primary SMTP address. Any ideas on the best way to do this considering the different Exchange platforms? In total there are over 25,000 mailboxes spread over 34 boxes so manual updates is just not feasible.
 
We will be totally upgrading our setup soon but we need to implement this for business reasons now

I know that we can do a directory export to a csv file, modify and then re-import on the 5.0 and 5.5 boxes. Can this be done on the Exchange 2000 and 2003 boxes as well?

Are there any limits to the number of records that can be imported in this fashion?
This is an urgent requirement
eoindarcyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zookeepa1Commented:
...Darcy,

What you are asking is actually fairly easy to do.  However...the outcome is a product of how well user information (detail) has been maintained across nework.  You can actual use a custom recipent policy in 5.5/2k/and 2003 to do just what you are trying to do.  Take a look at this link http://support.microsoft.com/default.aspx?scid=kb;en-us;319188 but (and here is the kicker)...If your various users or mailboxes need to have serveral different smtp addresses added; and your user detail is wrong it will make it more difficult.  FOR example let's say you have 3 users...Two in Chicago and a Third in DC.  

For the two Chicago users user-detail was correctly added to the the user profile and Chicago was placed within the address of those two users but on the DC user someone didn't add the location detail.  If you created a custom policy that created and applied an email address based on the location of containing the word "DC" this one user would not receive the new policy and thus would not receive the new address.  And if 4500 or so users were done the same way...you'd have a small problem.  But you can clean all that up before hand....and hopefully not run into any problems.

Also you can set the policy to set a new stmp address as the primary.  (sorry for being long winded)
0
kristinawCommented:
I'm not really following all of zoo's post, but anyways...here's my two cents. The csv directory import should work just fine for the 5.0/5.5 boxes. As for the 2000/2003 boxes, all you need is a recipient policy with the new address (or add the new address to the existing recipient policy) and you will be good to go.

Here's a link on how to set one up. The link zoo posted is actually about mailbox management, i think you'll find this one more useful:

http://support.microsoft.com/kb/319201

are all the servers, or at least the 2000/2003 servers part of the same Exchange organization?

Kris.
0
eoindarcyAuthor Commented:
Thanks Kristina,

This goes some of the way there but there is an added complication. Say a user has an existing address of jsmith@abc.com. The new SMTP address, which will be the primary address, will have the form john.smith@xyz.com.

Also there is no exact rule that can be logically applied if there is already a john.smith@xyz.com. We have created a database of all the old addresses and all the new ones so the csv import method is great. Will it work on Exchange 2000 or 2003?

Eoin
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

kristinawCommented:
the firstname.lastname method is no problem for the recipient policy. also, the second domain is no problem either. in my opinion you'd be much better off letting the policy handle this for the 2000/03 servers than trying to import any other way. should your company decide to change email formats later it will be a snap to change them if you're using a policy. Also, whenever you add a new user they will get both addresses by default. You won't have to add them manually.

The following shows you how to setup 2000/03 for multiple domains:

http://www.msexchange.org/tutorials/MF010.html

to get the firstname.last name format, you'll have a second recipient policy that will look something like this:

%g.%s@xyz.com

If there is already a john.smith@xyz.com, it'll automatically name them john.smith1@xyz.com, or something like that. we usually edit those manually. do you anticipate having a large number of these?

Kris.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
eoindarcyAuthor Commented:
Hi Kris,

Thanks for your reply and sorry for taking so long to get back.
I have tried out your suggestions on the 5.0 and 5.5 boxes and we are currently checking out the policies solution for 2000 and 2003.

Thanks for your help
Eoin
0
kristinawCommented:
excellent, do post back with your results, i'd like to know how it goes!

Kris.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.