0

I want to export all people from my address book to excel using UI-path. If possible or is there any other way to get the export of the outlook address book.

raj parihar
  • 25
  • 1
  • 7
  • I hate to be 'that guy' but probably not a good idea to export into an excel for GDPR protocols etc. Is there a reason to put it into Excel? – craig157 Mar 24 '21 at 17:07
  • Yes, there is a reason - I have a list of people(a dump of SharePoint list). where I would like to map the list (which I already have) with the outlook address book dump. Finally, non-matching email ids need to be flagged. – raj parihar Mar 25 '21 at 08:40

1 Answers1

2

You can develop a VBA macro which can do the job for you. The NameSpace.AddressLists property returns an AddressLists collection representing a collection of the address lists available for this session. The AddressLists collection represents the root of the address book hierarchy for the current session. A particular AddressList object represents one of the available address books.

Set myAddressList = Application.Session.AddressLists("Personal Address Book")

You may find the following articles helpful:

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45