Extracting Attachment from Outlook

Question

Hi,

I would like to ask assistance if there's a way to extract attachment from email. The emails are being save in the shared drive and from there I would like Alteryx to extract the excel files (attachment) and save it in another folder.

Please advise. Appreciate if you share screenshots on how to do it.

Thanks and looking forward.

Kamen

pairy · Answer

I have a solution for a tool that can help you to extract attachments from Outlook files without any problem you will get an individual file of attachments after extracting attachments from the PST file try this SameTools Extracting Outlook PST Items Software This tool has different and advanced features to work in instantly with windows OS this software supports Windows 10, 8.1, 8, 7, XP, Vista, etc. It can extract attachments from emails, contacts, notes, tasks, events, and other saved data in PST files users can work with PST MS Outlook 2003, 2007, 2010, 2013, 2016, 2021, etc. Try this tool with a free demo and see more features that are available in the tool for extracting attachments from Outlook.

More Information: https://www.sametools.com/outlook-extractor/

danialjohn · Answer

I've successfully pulled every attachment from an Outlook email, contacts list, calendar, date, time, and even draft data. osttopstapp Outlook PST Extractor Tool is an application that users should attempt if they wish to Extract Attachments from Outlook mailbox data. It can save the file at the selective location and allows users to individually extract each attachment and keep it in a new file or folder. When it comes to extracting attachments from To, Cc, Bcc, Time, and other locations, this is the greatest extractor program. Users may simply use this utility by installing the application, and here users will get a free preview option before extracting attachments from Outlook.

Visit here: https://www.osttopstapp.com/extract-outlook-pst.html

Amol_Telore · Answer

Hey @KamenRider

I am not sure how we can leverage only Alteryx to perform this task but I have another solution for this problem.

* Create a batch script

ECHO OFF

set in_folder="C:\Enter complete folder path where MSG files are stored"
set out_folder="C:\Enter the output path where files can be stored after extraction"

cd /d %out_folder%
del *.* /F /Q -- Please note that this comment deletes all the files in the specified folder. It has been included to remove files extracted during previous batch script run.

cd /d %in_folder%

for %%f in (".\*.msg") do python -m extract_msg "%%f" --attachments-only --no-folders --out %out_folder%​

* Save this file with the .bat extension. Once done, click on this file, and the rest will be automatically done in the background. 
* You can also parameterize it by giving input and output folders while running the batch script. 
* If your requirement is to complete this task through Alteryx then you can use the run command tool in Alteryx to run this batch script.

Note:-

* To run the above batch script, You need python installed on your machine.
* Also, you will have to install the Extract-Msg library if not done yet. To install this python library, run the below code in CMD.

pip install git+https://github.com/TeamMsgExtractor/msg-extractor​