In this step, you load a query into an Excel Data Model, in order to build a report connected to the query result. Step 3: Load a Total Sales per Product query into an Excel Data Model. 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. Enter your email address in the Mailbox Address field. Select Data (tab) -> Get Data -> From Other Sources -> From Microsoft Exchange. ![]() ![]() Now, click on the "Use this template" option. Search Outlook mail to Excel in the search bar and choose "Track emails in an Excel spreadsheet" Template. Best Regards, Community Support Team _ Lin TuStep 2. And select excel file only supports select from drop down, so if you want to get all rows from multiple excel tables, you should select them one by one. Set olF = (2) lrow = 1.If you want to get the excel file, you should use the list rows present in a table action. Set olNS = olA.GetNamespace ("MAPI") 'Select the folder number here where the first one is 0.
0 Comments
Leave a Reply. |