Parse through an email

[FernandoGarcia]

I have been tasked with going through daily reports we receive via email. These consist of basically a table embedded in the body of an email.

As it turns out, you can't just drag the email as an input in Alteryx. Anyone has any idea on how to go about this?

For anyone thinking on it, I am not keen on using the Outlook input tool as I would need administrator access.

I have thought of saving the emails individually as a TXT file and then parse them, but I have no clue as how to do it.

Format of the email is:

Text text text Text text text

Text text text

Text text text

Header	Header	Header	Header	Header	Header	Header	Header	Header
xx	xx	xx	xx	xx	xx	xx	xx	xx

And so on for an undertemined number of rows.

[mceleavey]

Hi @FernandoGarcia ,

Without using the Outlook tool you won't have access to the email, and so all you can do is manually copy and paste the table into Alteryx.

The Outlook tool is the answer.

M.