Excel VBA To Extract Attachments From .MSG Files (Outlook Mail) into a Folder
This excel VBA is used to extract all the attachments available inside a .MSG File (Outlook Mail) from input folder given and store it in the output folder given. It will process multiple .MSG Files available in the given input folder sequentially.
Execution Steps :
Step 1 : Click on 'Attachment Extractor - Click Here' Button in 'MACRO' Worksheet
Step 2 : In the input box, please provide Input Folder Path, where the .MSG Files are available
Step 3 : In the input box, please provide Output Folder Path, where the Attachments need to be stored
Step 4 : Please check into the output folder given after receiving the success message as, "Attachments Extraction from .MSG Files have been Completed".
Note : Based on the number of .MSG Files available in input folder, the macro execution time will be different.
It's working excellently well. I have used the tool to extract invoice documents from outlook mails. It's extracting thousands of attachments into a specified folder quickly. It also reduced the huge amount of manual effort in attachment extraction process. Completely satisfied. Thanks for sharing the code.
Nov 10, 2020