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

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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels