Need help fast!

I have one day left and I need to create over 1200 AD user accounts with mailboxes on exchange 2013. I work in the DoD so I'll need to use 1234567890 (as the user logon name), Last name, Rank, First name as the display name and first.last as the pre-windows 2000 user logon name. I'd like to accomplish this with powershell.
Rico YoungAsked:
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.

Daryl GawnSystem AdministratorCommented:
Rico YoungAuthor Commented:
I'm a beginner that's close to being at an intermediate level.
Pete LongTechnical ConsultantCommented:
Heres me doing something similar, Essentially I use a csv file with all the usernames in and then I read them in with PowerShell and create the users. Then I use another command to mail enable all the user accounts.

Mal OsborneAlpha GeekCommented:
If you don't NEED to use Powershell, you might look at going "Old School" and using CSVDE instead. This is an old utility designed to do pretty much exactly what you are trying too.

Here is a link to get you started.
Jose Gabriel Ortega CEE Solution Guide - CEO Faru Bonon ITCommented:
Well if you have the username of all users you can usethis:
1. Create a file.csv on the desktop (using the Excel)
on CSV
2. On the AD server run :  from a DOS Command: csvde -i -f "file.csv"
3. And to enable use Powershell on the server with this script

You can also change the $true on the Set-ADAccountPassword line.

I'll share my holy excel to create the number of users you want from a csv :)

3Simple steps like Dora the explorer :) hahaa

On the macro change this lines for your domain:
Dim DCs(1) ' de 0 a 1 = 2
DCs(0) = "DC=domain"
DCs(1) = "DC=com"

Open in new window


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
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

From novice to tech pro — start learning today.