Log In
Register
Home
Power Query & Outlook Public Folders
James Judd
New Member
Members
Forum Posts: 1
Member Since:
May 11, 2016
May 11, 2016
Offline1
June 30, 2018 - 6:18 pm
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
Catalin Bombea
Iasi, Romania
Admin
Forum Posts: 1807
Member Since:
November 8, 2013
November 8, 2013
Offline2
July 1, 2018 - 7:08 pm
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Lionel Baijot, Jack Brett, Ben Hughes
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Forum Stats:
Groups: 3
Forums: 24
Topics: 6211
Posts: 27238
Member Stats:
Guest Posters: 49
Members: 31891
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —