Hello, Could you please help about the following question? How to import contacts from CSV file into Exchange 2010 - including fields Office or Department? Because it is limited in commands of Shell. So I don't know if there are other ways to import them. For example, we can use scripts, or C# which can import them with field Office or Department. Because I think we based on fields that they are exist in contact object of exchange server. it include fields Department, Office, etc. Thanks in advance, Peace.

Hi Peace, You can try this way: Create a csv file c:\contact.csv, file format should be: name,emailaddress,office,department a,a@a.com,aa,ab ... Run the cmdlet Import-csv c:\contact.csv | foreach {new-mailcontact -name $_.name -externalemailaddress $_.emailaddress;set-contact -identity $_.name -office $_.office -department $_.department}Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Peace, Any updates on your issue?Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thank you very much for your information, Frantk Wang.