outlookuipathuipath-activity

How to get the dump/export of outlook's address book using UI-path or without UI-path?


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.


Solution

  • 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: