Hello,
What is the best way to export all users contacts (with all fields) into the MS Excel?

Does anybody know some Macro or script which can help with that?
I saw the Microsoft script, but it is very basic...I am looking for something more powerful.


Thank you

Hi,

On Outlook side, we can do this via the following method:

1. Change your view to a table view like the Phone List view;

• Outlook 2010 and Outlook 2013
  Home tab-> group: Current View-> Phone
• Outlook 2007
  View-> Current View-> Phone List
• Outlook 2003
  View-> Arrange By-> Current View-> Phone List
• Outlook 2002 and previous
  View-> Current View-> Phone List

2. Insert and arrange the columns you want to export to Excel

• Outlook 2010 and Outlook 2013
  Tab View-> group: Arrangement-> button Add Columns
• Outlook 2007
  View-> Current View-> Customize Current View-> button Fields
• Outlook 2003
  View-> Arrange By-> Customize-> button Fields

• Outlook 2002 and previous
  View-> Current View-> Customize Current View-> button Fields

3. Press OK until all the open screens are closed.

4. Press CTRL+A to select al your contacts.
(In Outlook 2007 and previous, you can also use Edit-> Select All)

5. Press CTRL+C to copy your selected Contacts.
(In Outlook 2007 and previous, you can also use Edit-> Copy)

6. Open up Excel and select cell A1.

7. Press CTRL+V to paste all contact information or use the Paste button on the Ribbon or on the Toolbar.

8. Save your Excel sheet.

Reference: http://www.howto-outlook.com/howto/exportcontacts.htm

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Since we are not the best resource for coding, if you want to do this for all users via Macro or Script, I'd recommend post a new question in one of the two following forums:

Outlook for Developers

http://social.msdn.microsoft.com/Forums/en-US/outlookdev

Script Center forum:

https://social.technet.microsoft.com/Forums/scriptcenter/en-US/home?forum=ITCG

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Steve Fan
TechNet Community Support