Channel: WiseOwlTutorials

Category: Education

Tags: attachmentssave filefree tutorial.msgsavedirdirectoryemailsdownloadattachmentloop through filestutorialemailmacromacrosloop through emailsonline trainingsave asfree trainingmessageonline tutorialexcelvbavisual basic for applicationsmsg fileoutlookwise owl

Description: By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! This video explains how to use VBA to loop through email message files saved in the file system and extract the attachments stored in them. You'll learn how to use the Dir function to find and loop through files, how to use the CreateItemFromTemplate method in Outlook and how to loop through the attachments collection. Chapters 00:00 The Question 00:24 Referring to Files with the Dir Function 02:43 Looping Through Files with the Dir Function 04:44 Creating Emails from Template Files 07:22 Looping Through Attachments 08:38 Saving the Attachments Visit wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!