Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Is it possible to read .msg file in Alteryx?

Gandalf_NotGrey
8 - Asteroid

Hello, I have a workflow where I need to read .msg files and convert the content of these email messages into pdf/word/excel output. Is it possible to do this in Alteryx?

I found out about reading a .msg file as .csv, but I was not able to build it.

Has anyone done this before?

Many Thanks.

2 REPLIES 2
ChrisTX
16 - Nebula
16 - Nebula

Yes, I read MSG files and parse them to get the attachment file name(s).

 

I use this configuration for the Input Data tool:

Read MSG file 1.png

You'll likely need to use RegEx to parse out readable text from data like this:

Read MSG file 2.png

Chris

Gandalf_NotGrey
8 - Asteroid

Thanks @ChrisTX for the response.

Your response is useful but in my case this does not works, since I am looking for multiple .msg files and each one is different from the other. Also, when I import it this way, a normal email message is returned back as a table with 1000s of rows with bits of useful information in each row and all that is mixed with Gibberish.

Thanks for looking into this, much appreciated.

Labels
Top Solution Authors