Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Can I extract an attachment from an Outlook .msg file from Alteryx?

Phyllis
7 - Meteor

I am sent an outlook .msg file that contains an attachment within it (not the attachment itself), which I have automatically forwarded to Box Sync. Is there anyway that the Alteryx workflow can open the .msg file and extract the attachment to use as my data source?

 

Thanks!

8 REPLIES 8
ivoller
12 - Quasar

I think that the answer is almost certainly yes but will depend on the environment.

 

If you have Outlook available on your system then one approach is to write VB Script that uses the application objects and methods to extract attachments to a file.

Phyllis
7 - Meteor

@ivoller wrote:

I think that the answer is almost certainly yes but will depend on the environment.

 

If you have Outlook available on your system then one approach is to write VB Script that uses the application objects and methods to extract attachments to a file.



I would like to avoid this if possible as multiple people will be using the workflow who do not have access to the email within Outlook and only on Box. Thanks!

Treyson
13 - Pulsar
13 - Pulsar

Here are two great articles that should help get you started. If you need any help beyond this, please let us know!

 

https://community.alteryx.com/t5/Engine-Works-Blog/Outlook-Input-tool-Created-with-the-Alteryx-SDK/b...

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Reading-Outlook-Emails-and-Email-attachments...

Treyson Marks
Senior Analytics Engineer
Phyllis
7 - Meteor

@Treyson wrote:

Here are two great articles that should help get you started. If you need any help beyond this, please let us know!

 

https://community.alteryx.com/t5/Engine-Works-Blog/Outlook-Input-tool-Created-with-the-Alteryx-SDK/b...

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Reading-Outlook-Emails-and-Email-attachments...


I had already read these but I'm understanding that these are if you are running the workflow which extracts the attachment from Outlook itself, correct? I'd like to share the workflow with other users who hopefully can pull this .msg from Box and have Alteryx extract the attachment within. I understand this is a really weird situation. 

Treyson
13 - Pulsar
13 - Pulsar

Okay so you actually have the .msg file, which I would imagine is in some shared location, and you want to go in and extract the file within the .MSG file? Can I ask why it would be done that way?

 

I think it can be done. Let me play around and I will see what I can do.

Treyson Marks
Senior Analytics Engineer
Treyson
13 - Pulsar
13 - Pulsar

So I also found this one, not sure if you had read it yet. It says that Alteryx cannot natively read .msg files. Which I tried to do and failed.

 

This route uses access to pull information from the MSG but is unable to pull the attachment. 

 

https://community.alteryx.com/t5/Data-Sources/Is-there-a-way-to-convert-an-e-mail-pst-file-to-a-csv-...

Treyson Marks
Senior Analytics Engineer
mhayashi
7 - Meteor

Same end for me.

leotalley
5 - Atom

You asked a good question, if I give suggestions from my personal technical experience, Try Softaken MSG Attachment Remover Application is an Extract of an attachment from an MSG File without installing Outlook.

Labels