We will look at how to extract or download attachments from Outlook emails using two different methods. First way, is by connecting directly to Outlook. And the second way, would be to manually copy the emails onto a local folder on our computer, and then run our code over those saved emails. Both achieve the same result. However, I prefer the 2nd method and I will give my reasoning in the last section of this video.
This is a Concepts video. I plan to use this concept in several of my upcoming projects where we tackle real-life scenarios. I will link these videos below as I upload them.
• Excel VBA Automation Project | Send Report...
If you want to checkout, how to download attachments and merge them together in one single macro flow, I will cover this in my next video.
• Excel VBA || Split and Merge Files
Code can be found at:
https://skillsandautomation.com/usefu...
Macro file can be downloaded from:
https://github.com/skillsandautomatio...
Time Stamps
00:00 Intro
00:46 Demo
02:17 Connect Directly to Outlook
06:07 Use Saved Emails
10:14 (Subjective) Comparison