VBScript to create new users

Hi,
I'v been asked to create more than 200 new users account & their exchange
mailboxes. I have all the information in Excell file
First Name
Last Name
Initials
I wonder if there is any way to write a VBScript how read the user
infromation from the Excell file and create the USER Account & MailBox in our
AD.
thanks for your help

Windows platform is: windows server 2003 & Exchange Server2003

Richard,

Your script is really handy and helpful.

I do modified the script to add my full name to the DisplayName to user's
properties, and it does show on the Start menu of WinXP when user login, but
it do not show the full name in the list of user under "Active Directory
Users and Computers" of WIn2003, instead, the same value of the user name is
displayed.
Please note that the full name is feed from manual Excel input.
Please help!

Many thanks

"Richard Mueller [MVP]" wrote:

>
> "IT-Guy" <ITGuy DeleteThis @discussions.microsoft.com> wrote in message
> news:022402FA-1CEA-4726-8901-41679C165EB4@microsoft.com...
> >
> >
> > "Richard Mueller [MVP]" wrote:
> >
> > > IT-Guy wrote:
> > >
> > > > Hi,
> > > > I'v been asked to create more than 200 new users account & their
> exchange
> > > > mailboxes. I have all the information in Excell file
> > > > First Name
> > > > Last Name
> > > > Initials
> > > > I wonder if there is any way to write a VBScript how read the user
> > > > infromation from the Excell file and create the USER Account & MailBox
> in
> > > our
> > > > AD.
> > > > thanks for your help
> > > >
> > > > Windows platform is: windows server 2003 & Exchange Server2003
> > >
> > > Hi,
> > >
> > > I have not worked with Exchange, but I have a sample VBScript program to
> > > create users from an Excel spreadsheet linked here:
> > >
> > > http://www.rlmueller.net/CreateUsers.htm
> > >
> > > You possibly can modify this for your purpose.
> > >
> > > --
> > > Richard
> > > Microsoft MVP Scripting and ADSI
> > > Hilltop Lab web site - http://www.rlmueller.net
> > > --
> > >
> > > thanks Richard for your help..
> > I modified the Script and its working fine. The other think that I noticed
> > is the Display Name is not in the same format that I hade in my Active
> > directory. When I manually create new user the display Name format is Last
> > Name, First Name. But when I do it by using the Script the Display Name is
> > Empty!! Is there any way to get the display name format (Last Name, First
> > Name) thanks for you advice and help.
> > >
>
> The GUI constructs the display name for you from the values you assign for
> other attributes. The name of the attribute is displayName. My example does
> not assign a value to this, but the script can be modified to do this. You
> could have the script construct the value the way the GUI does, or use a
> formula in the spreadsheet to contruct the value in a new column.
>
> To match what happens in the ADUC GUI, you could assign displayName with
> something like this:
>
> objUser.displayName = strFirst & " " & strMiddle & ". " & strLast
>
> I used the variable names from my example script. This statement could be
> added to the script where the other attribute values are assigned. For the
> format you describe, you can use:
>
> objUser.displayName = strLast & ", " & strFirst
>
> --
> Richard
> Microsoft MVP Scripting and ADSI
> Hilltop Lab web site - http://www.rlmueller.net
> --
>
>
>