Hello, Please help, is there a way to import an excel file that has the email addresses to the GAL or is there any other way beside we have to use the MIIS for the GAL Sync? This is very urgent please reply asap Mai

Sure, its pretty simple - lay your addresses out according to the following example then save as a CSV and import into A/D using csvde. kb327620 Table: objectClass DN displayName mailNickname targetAddress contact cn=Sample User, ou=Organisation Unit, dc=Domain, dc=SUFFIX Sample User user.s SMTP:user.s@externaldomain.com This is the minimum amount of information required to create a mail enabled contact in Windows 2003 A/D & Exchange environment. If you want you can drop me a mail n I will send you the xls file I use to import contacts into AD. Save you lots of time.

hello could you send me the xls you use to import contacts into AD? I would greatly appriciate it. Also is it possible to import phone numbers, address and etc.? Basically my company is merging within another and we have to imort our merging companies, contact information, email, address, phone # and etc. Thanks Garry

Hi Garry, I have emailed you the file - a word of advice, perhaps it is a good idea to edit the previous entry & remove your email add sometime soon. Let me know how you get on. I also have one for Exchange Server 2007, in case you need it.

Hi Johan, would love to have a copy of this file. I am trying to import information to excisting users in AD. Is this possible?Thanks, (ignore_ and dot = . p(dot)slaghekke_at_(gmail_dot_com)

Hi Petrus, I can give you a script for Exchange 2007 which will update existing users but since the one I have for 2003 is based on csvde & csv files, it cannot be used to update existing objects, only create new ones. To update objects you need to make aldif file & import the data using ldifde. the urls below are pretty comprehensive though. http://searchwinit.techtarget.com/tip/0,289483,sid1_gci1201019,00.html http://www.2000trainers.com/windows-2000/csvde-ldifde/ or if you have Exch 2k7 in your organization, just let me know & il send the script accross.

Hi John,Would you mind to email me the files for 2003 and 2007 as well please?We will also be extracting users from 2003, then import them back to 2007.

Hi Johan, Any chance of emailing me the excel file you use as a template to import into AD for exchange 2003. my email address: josh.uddin@msn.com many thanks, - Josh

Hi Josh, I have actually posted the files on my blog:Exchange 2003 Contacts UploadExchange 2007 Contacts UploadIt just seemed so much easier that way than to keep having to mail it out and people posting their email ID's on this forum.