Это видео недоступно.
Сожалеем об этом.
Power Query - Data from Email Attachment
HTML-код
- Опубликовано: 17 авг 2024
- 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
I've never seen anything like this! Simply extraordinary!!
I agree; it is pretty cool.
It’s almost like you’re watching my machine to see what problem I’m trying to solve 😂. Thanks so much for this. Not only are your videos perfectly presented (for me), they are so on point.
Glad to be of service. I'll keep monitoring your computer for future video topics 😄
Great video, this will spawn lots of use cases…
Glad to hear the video will help!!! Thanks for watching.
You were so right… I love this video. Thank you.
@@noneyabeezwax8865 Glad you liked it. Thanks for watching.
Definitely going to try this
and if it works apply this.
Thank you for this.
@@excel_along_the_way You are most welcome. Good luck, and let us know how it turns out.
thank you my friend. Hope everything ok on your side. It's a mad world out there in the USA now. Best wishes.
.
Yep; things are a bit crazy here. It will all work out in the end. Thanks for the support.
Amazing and brilliant (both the video and you)!
@@mcegirl4 That is so sweet of you to say. I told my wife; she rolled her eyes.
@@bcti-bcti 🤣 (I think that’s her job!)
🙀 as always amazing 🙏 for sharing your knowledge with us. Very very helpful.
So glad it was helpful. Thanks for watching.
Wizardry for sure.😀 but I like it. 🤩😍
My work won’t let me use the skills I already have but I sure is fun watching a proper expert at work and I will continue to watch and learn just for the fun of it.🤩😍
@@DingusBatus thanks for the support!!!!
Please cover connecting to a Gmail or Google workspace account. That would be so useful. Thanks!
I did spend some time looking into that as another video, but all I found were some rather expensive 3rd-party options to do that; nothing built in to Power Query. Microsoft really need to approve some sort of "free", included connector for those platforms. Thanks for watching.
Outstanding !
Thank you!!!!
Cool! It is crazy simple and great. Maybe vídeo for gmail after a 🤠
@@danielgoncalveslima9350 I’ll see what I can do. Thanks for watching.
Wow, brilliant! Thank you!
OMG, just what I need. I have 2 files that come in twice a month that I need to report on. Although they have the same data, they are laid out differently. I should be able to separate them and process them separately. I've gone into Outlook for survey data, but hadn't thought of if for this application. Thanks for the direction for my real world problem.
@@1qtaz I love it when people say that. It makes it all worth while. Thanks for watching.
Fantastic!
You never cease to amaze!
Thanks. I'll try to keep up that trend.