CODEWITHSUNDEEP
powershelloutlookexchange-servergal
Mark
Mark

Reputation: 326

Can I export outlook address book to csv as a common user?

I am not exchange admin but just a common user. I believe we are using Exchange 2019 and the address book (is it called GAL?) is saved in server side. I can open and search it via my Outlook interface.

Beside Outlook program I have access to PowerShell. I tested $Outlook = NEW-Object -comobject Outlook.Application and I can successfully get the object.

I want to export the address book (users and groups) into csv by UI or PowerShell. How can I do it?

Upvotes: 0

Views: 1747

Answers (1)

Eugene Astafiev
Eugene Astafiev

Reputation: 49455

You can automate Outlook from PowerShell to get all the required information. The NameSpace.GetGlobalAddressList method returns an AddressList object that represents the Exchange Global Address List. GetGlobalAddressList supports only Exchange servers. It returns an error if the Global Address List is not available or cannot be found. It also returns an error if no connection is available or the user is set to work offline.

Take a look at the following pages for more information and sample code (VBA, but the Outlook object model is common for all kind of programming languages):

Upvotes: 1

Related Questions