Reading an email body with SharePoint input

[Domo]

Hello all,

I'm trying to capture the body of emails by using Outlook to send emails to SharePoint (access database) and Alteryx SharePoint input to return this data.

I'm guessing that SharePoint been web based, Alteryx must be reading the body as html. 

Is there a better process than what I currently have? and if not, is there a way I to convert html?

Cheers.

Domo

[mszpot89 · Accepted solution]

I created an access .mdb data base and created data source from Outlook folder.

Once import is complete the body of the table is normal text, not html code under Contents attribute.

After that create an input connection in Alteryx:

[Domo]

Hello all, Although using access as a middle point is a good solution I found a better one. Download the OutlookInputTool tool and connect it to the exchange. It words a treat... Thanks everyone!!!

[Domo]

That's if you are using Outlook. https://community.alteryx.com/t5/Engine-Works-Blog/Outlook-Input-tool-Created-with-the-Alteryx-SDK/b...