These tables make it easy to import the full data then filter and sort the data in any way you need. If you click on one of the listed tables you can see a preview of the data in that table, such as all the email folders and their contents. Power Query creates a connection to the Outlook mailbox and displays the top-level sections of the account. Provide your password and click the Connect button to proceed.

In this example, I will use my email address associated with my Microsoft account.

Further connections will utilize the same credentials provided at this step. If this is the first time you have connected to your Outlook account using Power Query, you will need to provide your account name and password to permit Power Query the needed access to your Exchange email. Select Data (tab) -> Get Data -> From Other Sources -> From Microsoft Exchange.Įnter your email address in the Mailbox Address field. We begin by starting a blank workbook in Excel and creating a connection to our Outlook Inbox using Power Query. If I can send all these messages into an Excel Table, reading through and processing the messages will be a bit easier to manage. We want to bring in only the messages stored in the “ Action Required” folder below the main Inbox folder.

Power query mac 2021