Forum Discussion

krikri's avatar
krikri
New Member
1 year ago
Solved

Create Turn Around Time from Email Inbox and Reply response time from outlook

We have a shared Inbox for my team that receives daily requests. Shared inbox is: [email protected] I would like to record the Email info: From; Subject; Received Time; and Categorize if ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi krikri ,

    Your needs are not quite clear, are you trying to import data from your email into Power Query in the format you want?
    If the mail you are using belongs to the Exchange service, you can try the following connection methods:
    Microsoft Exchange Online Power Query Data Connector - Power Query | Microsoft Learn
    But this doesn't allow you to customize what to import.

    If your mailbox is not part of the Exchange service, then you may not be able to connect directly to the contents of that mailbox, and you may need to use other tools to export the data first and then connect to Power Query.

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.