Is possible to list all user in outlook and retrive the info marked in image?
Via vba for excel.
Tks.
listing all user in Outlook
-
- PlatinumLounger
- Posts: 4368
- Joined: 26 Apr 2010, 17:36
listing all user in Outlook
Last edited by sal21 on 01 Jul 2019, 13:41, edited 1 time in total.
-
- Administrator
- Posts: 12628
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: listing all user in Outlook
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
-
- 3StarLounger
- Posts: 397
- Joined: 24 Jan 2010, 19:43
- Location: Salt Lake City, Utah, USA
Re: listing all user in Outlook
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>"
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
I float in liquid gardens