Forum Discussion

masplin's avatar
masplin
Icon for Power Participant rankPower Participant
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
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi masplin,

After research the blog you posted, you can query the needed data from Exchange mailbox. Then use the data to create a report, the report will update everytime you refresh your data. For your requirement, I am really confusing the flag status. And what's the meaning of using the flag function? Could you please share more details for further analysis?

In addition, could you get the data from mailbox just like the data from the “Affiliates’'\Exceluser.com” folder. And filter the data as the following screenshot?



Best Regards,
Angelia

 

  • masplin's avatar
    masplin
    Icon for Power Participant rankPower Participant
    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

    • zbognar's avatar
      zbognar
      Regular Visitor
      8 years ago

      hi Masplin,

       

      I'm strugguling with the same issue... have you found out the solution?

       

      Regards,

      Zoli

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Dear Masplin / Zoli

      Have you got the solution for this issue. 

      Please suggest