+ Post New Thread
Results 1 to 5 of 5
Windows Thread, Bulk Import Contacts into Exchange 2003 in Technical; We are looking to add details of parents names and email addresses as contacts in Exchange 2003 so that the ...
  1. #1

    Join Date
    Nov 2007
    Location
    Manchester
    Posts
    206
    Thank Post
    2
    Thanked 13 Times in 7 Posts
    Rep Power
    17

    Bulk Import Contacts into Exchange 2003

    We are looking to add details of parents names and email addresses as contacts in Exchange 2003 so that the Head or other necessary staff can easily email parents either in bulk (via distribution list) or seperately through Outlook. We want to put it into exchange so that when/if details change we only have to make the change in one place (rather than each user making their own distribution list and altering each time)

    I will export the details out of SIMS.net, but what order/format should I sort the data into and how do I go about bulk importing contacts in Exchange/AD?

    I could just create the initial list of contacts for AD manually...... but I'd rather not!

    Alternatively, how have your schools got your parents email addresses stored so that Senior Management or whoever can email them easily, but with a centralised management of the email addresses.

    Cheers in advance.
    Last edited by TheFopp; 15th January 2008 at 12:32 PM.

  2. #2
    mrforgetful's Avatar
    Join Date
    May 2006
    Posts
    1,639
    Thank Post
    7
    Thanked 15 Times in 15 Posts
    Rep Power
    23
    Your SMT use email?

  3. #3

    Join Date
    Nov 2007
    Location
    Manchester
    Posts
    206
    Thank Post
    2
    Thanked 13 Times in 7 Posts
    Rep Power
    17
    Quote Originally Posted by mrforgetful View Post
    Your SMT use email?
    I know.... its a miracle!

  4. #4

    Join Date
    Jun 2007
    Location
    Barton-Le-Clay
    Posts
    20
    Thank Post
    0
    Thanked 5 Times in 3 Posts
    Rep Power
    15

    Bulk import using CSVDE

    Hi,

    I don't know if you've solved this or not, but my HT just asked for the same facility.
    After a little digging, I found the correct file format to allow me to bulk import contacts (ie, users without a domain logon) into the AD and Exchange 2003.

    The .csv attached only configures the bare minimum required to create a contact, but if you want to add more details you just need to know the AD schema names.

    To import your users, edit the contents of the DN column to match your domain, fill in the other columns accordingly, and then run CSVDE on the server with this syntax:

    csvde.exe -i -f parents.csv -j c:\

    The "-j C:\" is optional, but useful as it saves a log file for the job.

    All you need to do after this is done is create a distribution group within the AD and add all the imported users to that group. You may wish to change the SMTP address of the group, otherwise parents will be able to email all of the other parents! (I changed mine to Parents@Arnold.Middle - exchange allows it, but mail to this address goes nowhere).

    Any questions or problems, drop me a line.
    Hope all this helps,

    Ian
    Attached Files Attached Files
    Last edited by ilisle; 24th November 2008 at 12:08 PM.

  5. Thanks to ilisle from:

    SmaraitanCollege (11th June 2009)

  6. #5

    Join Date
    May 2010
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Very nice solution

    Soundje

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 11
    Last Post: 22nd May 2008, 08:23 AM
  2. Exchange Personal Contacts
    By tscnmuk in forum Windows
    Replies: 8
    Last Post: 11th June 2007, 07:29 PM
  3. Replies: 2
    Last Post: 30th January 2007, 10:27 PM
  4. Replies: 2
    Last Post: 14th September 2006, 10:27 AM
  5. Replies: 4
    Last Post: 27th May 2006, 02:48 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •