none
Extract Outlook Contacts from Mailboxes on Exchange Server

    Question

  • Is it possible to export Contact details from numerous users Exchange mailboxes (e.g. Exchange 2010)?

    From my reading one possible way of doing this is with the "Export-Mailbox" command. However, Exchange isn't my main area of expertise and am bit unsure of these methods. Ideally the data could be exported to a CSV format rather than a PST.

    Thanks,


    • Edited by nhelen Wednesday, September 21, 2011 11:02 AM
    Wednesday, September 21, 2011 11:02 AM

Answers

  • Hi nhelen,

    You can go through multiple mailboxes and export their contacts into a single PST file by running something like:

    New-MailboxExportRequest -Mailbox nuno -FilePath <a href="file://\\server\C$\Users\adminmotan\Documents\contacts.pst" rel="nofollow">\\server\C$\Users\adminmotan\Documents\contacts.pst</a> -IncludeFolders "#Contacts#" -ExcludeDumpster
    

    You can run this command for multiple mailboxes and export all contacts to the same PST file.

    Or you can automated with something like:

    "mailbox1", "mailbox2", "mailbox3" | New-MailboxExportRequest -FilePath \\server\C$\Users\adminmotan\Documents\contacts.pst -IncludeFolders "#Contacts#" -ExcludeDumpster
    

    However, you have to change the code so that only one export is done at a time otherwise you will encounter errors as the PST file will be locked by one export.

    Now, to update contacts and save them back, that's another complete story... For that, you would have to use EWS...

    Hope this helps!
     


    http://LetsExchange.blogspot.com
    Wednesday, September 21, 2011 2:55 PM

All replies

  • With Exchange 2010 SP1, Export-Mailbox is gone. It has been replaced with New-MailboxExportRequest. However, neither can be used to export to a .CSV file.

    The only way I know, is to export from Outlook. Here are links to manual ways. But you'll surely find some VB-Scripts on the Internet that automate this process.

    Outlook 2010: Export contacts
    http://office.microsoft.com/en-us/outlook-help/export-contacts-HA101870639.aspx

    Outlook 2007: How to Export Your Outlook Contacts to a CSV File
    http://email.about.com/od/outlooktips/ss/Export_Outlook_Contacts_to_CSV.htm

    General: Outlook 2003, 2007 and 2010
    How to import and export text data by using Outlook
    http://support.microsoft.com/kb/290859/en-us

    A look at the Import/Export Mailbox improvements in Exchange 2010 Service Pack 1 (Part 1 and 2)
    http://www.msexchange.org/articles_tutorials/exchange-server-2010/management-administration/look-import-export-mailbox-improvements-exchange-2010-service-pack-1-part1.html


    MCTS: Messaging | MCSE: S+M
    Wednesday, September 21, 2011 12:39 PM
  • Thanks Jon-Afred. I have successfully exported Contacts from Outlook clients to PST and CSV, however I was looking for a more automated means of doing this, and via the Exchange Server seem the sensible way of doing this (if it was possible).

    The original rquest put to me was for someone means of iterrogating Contacts data from multiple Exchange mailboxes (users), editing it to a common standard, and saving changes. Or if necessary, extracting it to a format like CSV, editing it, and pumping it back into the mailboxes (overwriting the existing Contact).

    From my reading, and the responses, I guess this is just not possible?

    Wednesday, September 21, 2011 2:35 PM
  • Hi nhelen,

    You can go through multiple mailboxes and export their contacts into a single PST file by running something like:

    New-MailboxExportRequest -Mailbox nuno -FilePath <a href="file://\\server\C$\Users\adminmotan\Documents\contacts.pst" rel="nofollow">\\server\C$\Users\adminmotan\Documents\contacts.pst</a> -IncludeFolders "#Contacts#" -ExcludeDumpster
    

    You can run this command for multiple mailboxes and export all contacts to the same PST file.

    Or you can automated with something like:

    "mailbox1", "mailbox2", "mailbox3" | New-MailboxExportRequest -FilePath \\server\C$\Users\adminmotan\Documents\contacts.pst -IncludeFolders "#Contacts#" -ExcludeDumpster
    

    However, you have to change the code so that only one export is done at a time otherwise you will encounter errors as the PST file will be locked by one export.

    Now, to update contacts and save them back, that's another complete story... For that, you would have to use EWS...

    Hope this helps!
     


    http://LetsExchange.blogspot.com
    Wednesday, September 21, 2011 2:55 PM
  • Just from doing all my research, I've come across "Mail Contacts" - these are explained as "Mail contacts are mail-enabled Active Directory objects that contain information about people or organizations that exist outside your Exchange organization. Each mail contact has an external e-mail address."

    http://technet.microsoft.com/en-us/library/aa998858.aspx

    These do not appear to have any relation to the Outlook Contacts within a user's mailbox. Can someone just confirm this, and what exactly is there point?

    Wednesday, September 21, 2011 4:06 PM
  • That is correct, they have nothing to do with one another!

    Outlook contacts are personal contacts that each user have.

    Mail Contacts are contacts in Exchange that can be visible to everyone in the GAL (or not) and that can also be used in Distribution Lists for example.

    According to the Microsoft definition: "A mail-enabled Active Directory contact that contains information about people or organizations that exist outside the Exchange organization. Each mail contact has an external e-mail address. All messages sent to the mail contact are routed to this external e-mail address."

    For more information: Understanding Recipients


    http://LetsExchange.blogspot.com
    Wednesday, September 21, 2011 4:10 PM
  • outlook pst software is very capable software .This software is easily extract calenders ,contact ,email address,phone numbers without altring the data.

    visit here:- 

    http://www.softakensoftware.com/outlook-attachment-extractor.html
    Tuesday, April 10, 2018 5:58 AM