listing all user in Outlook

User avatar
sal21
PlatinumLounger
Posts: 4368
Joined: 26 Apr 2010, 17:36

listing all user in Outlook

Post by sal21 »

Is possible to list all user in outlook and retrive the info marked in image?
Via vba for excel.
Tks.
Last edited by sal21 on 01 Jul 2019, 13:41, edited 1 time in total.

User avatar
StuartR
Administrator
Posts: 12628
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: listing all user in Outlook

Post by StuartR »

You can export your Outlook contacts to a CSV file (instructions here) and then import the CSV file to excel and delete the columns that you don't need.
StuartR


User avatar
Goshute
3StarLounger
Posts: 397
Joined: 24 Jan 2010, 19:43
Location: Salt Lake City, Utah, USA

Re: listing all user in Outlook

Post by Goshute »

For code solutions see http://msdn.microsoft.com/en-us/library ... 08926.aspx" onclick="window.open(this.href);return false; and http://www.jpsoftwaretech.com/export-ou ... -to-excel/" onclick="window.open(this.href);return false;

At a glance, some enhancements I would consider are (1) using the Outlook PickFolder method such as "Set fldrContFldr = Application.GetNamespace("MAPI").PickFolder" to handle the possibility of multiple Contacts Folders (the code examples assume the default Contacts folder), and (2) making sure that each Contact Item is a single Contact (as opposed to a Distribution List), such as "If fldrContFldr.Items(lngCounter).Class = olContact Then <...process>"
Goshute
I float in liquid gardens