Is it possible to read .msg file in Alteryx?

Question

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.

Gandalf_NotGrey · Answer

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.

ChrisTX · Answer

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

I use this configuration for the Input Data tool:

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

Chris