Forum Discussion
masplin
Impactful Individual
Impactful IndividualQuerying Exchange mailbox
Hi I found a great post of using power query to interogate the messages in a mailbox https://www.excelguru.ca/blog/2014/01/09/using-powerquery-with-email/ This works prett much perfectly, but...
You need to expand the attributes column in the email table (records) and select TaskDateCompleted. You do this by editing the table after you have imported the outlook email data.
I use the TaskDateCompleted to calculate how many days have passed from the date an email is received before the email is marked completed. Attributes.ExtendedProperties.TaskDateCompleted
Oskar
was anybody able to query user defined mailbox fields? The ones which you can create via Outlook.
Many thanks for your help. :)
Best Regards
Mr. IT