Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
100
Views
Topic starter
I need to build a database of members who attend various working groups. I can access this data in Public Folders in Outlook because each working group has an email distribution list which is maintained and updated in real time.
Is there a way to access this data using Excel and Power Query?
Any hints would be greatly appreciated.
Many thanks in advance.
James
Posted : 01/07/2018 4:18 am
Hi James,
You should setup a shared excel file using OneDrive, or even google sheets, you will be able to connect to that file from Power Query.
To connect with Public Folders in Outlook, vba is the only way.
Posted : 02/07/2018 5:08 am
