Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
128
Views
Topic starter
Hi All,
I am sure that this is a very simple question, but how can I connect to my outlook (not exchange) using Power query. I have created a folder in outlook of people who have replied to me. What I want to do is to use power query to extract the email address, but I don't know how to connect to the .pst file.
Thank you in advance
Chris
Posted : 09/09/2020 5:34 am
Hi Chris,
I'm not aware of a way to connect PQ to read from your PST file. If your email was connected to Exchange that would be a different matter.
I have written some VBA to read your Inbox (or other folders)
Extract email address from Outlook Messages
Regards
Phil
Posted : 09/09/2020 7:06 am
Topic starter
Thank you for that, that sounds as good a solution. I will check it out. I had hoped that PQ would work, but hey ho!!
Posted : 10/09/2020 12:34 pm
