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
Oceanopticon's avatar
Oceanopticon
New Member
8 years ago

I have the same question.  How can I get access to additional fields from Outlook?  The built-in connector in PowerQuery only makes a limited number available.

  • oskarjo's avatar
    oskarjo
    New Member
    8 years ago

    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

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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