Forum Discussion

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
9 years ago

Querying 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...
Need Help
masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
9 years ago

I can do everythnig this post suggested. However in outlook there is a function ot flag a message for follow up. I cannot find this field under any of the fields shown in the query. i checked every column and table including al lthe attributes and its not there.  I can see catagories, read status etc, but not flags.

 

In the example below I have put flags on 2 messages and one I marked complete.  This data must be avaialbe somewhere?

 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi masplin,

I am not specific about Exchange how works and how it stores data on the server. I personally suggest you post it to Exchange forum to confirm where the data is stored. Thanks for understanding.

Best Regards,
Angelia