Powery Query to Connect to Outlook GAL to Extract Email Adress

legalhustler

Well-known Member
Joined
Jun 5, 2014
Messages
1,080
Hi,

Is there a way for Power Query (PQ) to connect to Outlook Global Address List (GAL) so I can retrieve email addresses based on another table that has a list of aliases? Should PQ use get data from Microsoft Exchange or Active Directory? Please advise on how I can do this. TIA!
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Watch MrExcel Video

Forum statistics

Threads
1,102,561
Messages
5,487,571
Members
407,605
Latest member
PACULA

This Week's Hot Topics

Top