Learn Exchange the Guru way !!!


Create mail enabled contacts in bulk

This is a quick tip

In many organizations we need to create bulk contacts creation which is mentioned below:

Create an input file name contacts.csv with the following attributes and values



Open the Exchange management shell and run the below cmd after copying all contacts to the path of shell:

Import-Csv “contacts.csv” | ForEach {New-MailContact -Name $_.Name -Firstname $_.FirstName -LastName $_.LastName -ExternalEmailAddress $_.ExternalEmailAddress -OrganizationalUnit “Domainname/OUname”}

Prabhat Nigam (Wizkid)
Team@ MSExchangeGuru

13 Responses to “Create mail enabled contacts in bulk”

  1. Resource Says:

    It’s such as you master my head! You seem to realize lots about it, that you published the novel there or anything. I do think you’re able to do with some % in order to pressure the message home somewhat, nonetheless as opposed to which, this really is terrific blog. A wonderful study. I will be backside.

  2. Bingham Goods Says:

    Spectacular site. Plenty of information right here. I am mailing the idea in order to many associates ans also expressing throughout scrumptious. And obviously, great work!

  3. Naeem Says:

    This information is really good. I was looking for this from days and finally found it. 🙂 Thanks a lot for share the information.

  4. AbdulGani Says:

    how to import Phone numbers and Mobile numbers

  5. Prabhat Nigam Says:

    @Abdul: Try the cmd mentioned in the below technet

  6. Aravind Says:

    Hello Prabhat,

    Thanks for the Poweshell command which was much useful for us at the time of migration.

    If you could help me n adding the LegacyExchangeDN value and Alias value that would be great.

    Thanks in Advance.


  7. Babiyan Says:

    Thanks for the Poweshell command. I want to add the Office and Company details for the New-MailContact.
    Pl give me the Powershell command. Awaiting your reply.

  8. Prabhat Nigam Says:

    This link should help –

    check this blog. Seems you didn’t search our website.

  9. Paul Wagner Says:

    That worked perfectly in Exchange 2010 in AD 2012 environment. Thanks!

  10. Ann Says:

    Thank you SO MUCH for the easy-to follow instructions – this worked perfectly when I had to create 450+ contacts for a distribution list!

  11. Pratik Says:

    Can we have script to update existing contact in bulk.

  12. Prabhat Nigam Says:

    Why do you need to update all contacts?

  13. John Says:

    Pratik – There’s always the ever-reliable ADModify.NET tool for bulk changes. I’ve used it to add/modify common attributes like company/location for a group of contacts in an OU. No PS needed, but it’s easily done with PS as well.

Leave a Reply




Do NOT follow this link or you will be banned from the site!