This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 03-31-201602:36 PM - edited on 03-11-201909:49 AM by SydneyF
Can I read Outlook emails and attachments with Alteryx?
As our users are looking at automating their processes within Alteryx, the type of files they want to be able to read varies from your regular data file types. I was asked a few times if we could read outlook emails and/or attachments with Alteryx.
One way to accomplish this is by linking the Outlook folder (s) to an Access database table (s) and then to read the Access database with Alteryx, since it is a link, the table(s) in the Access database will be updated with all the emails that are being moved into that Outlook folder.
Once the Access table(s) is linked to the Outlook folder(s) you are ready to read it into Alteryx. Go to Alteryx and bring an Input tool and browse to the Access database file. Most likely the table tab won’t be populated, go to the SQL Editor tab and write the query as shown below, where Training is the name of your table in Access, then click OK.
Upon workflow execution, you will retrieve all this information from your Outlook emails
Reading Email Attachments
A rule can be created in Outlook to automatically download attachments to a specified computer folder where Alteryx can pick them up. There is a good article that walks through the setting of this Outlook Rule.
Notice that the script is where the folder to download is specified, specific line is saveFolder = "c:\temp\"
As always, do a small test first with a controlled outlook folder. Once this rule is set, you would simply point to the file(s) with an Alteryx Input Data tool.