Learn how to use Power Query's Exchange Connector to connect to your email and read data directly from an email attachment without having to save or open the email attachment.
File Download Link:
www.bcti.com//...
Video on Avoiding "Helper Queries" in Power Query:
• Power Query - Avoid "H...
00:03 Overview of Process
00:57 Scenario 1 - Overview
01:24 Scenario 2 - Overview
01:40 Power Query M Code Download
03:03 Creating an Outlook Folder to Hold New Emails with Specific Attachments
03:55 Connecting to an Email Folder
06:07 Extracting Data from Email Attachment
07:45 Test to Bring in New Data
09:04 Create Query to Append New Data to Report
10:46 Testing the Append Email Data Query
Негізгі бет Power Query - Data from Email Attachment
No video
Пікірлер: 31