on 03-31-2016 02:36 PM - edited on 07-27-2021 11:42 PM by APIUserOpsDM
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.
Reading Emails
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.
This Link walks you step by step on how to link an Outlook folder to an Access database table http://www.fmsinc.com/microsoftaccess/email/linked/index.htm
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.
Hello
What if it's not an attachement but a Link to Download ?
The attachement is served in an external server and I have to click to downlaod it.
Thanks
Hey @MargaritaW and @dataMack,
Thanks for this post!
Is it possible to extend this solution to set up something that can read the EMAIL BODY which has GRID REPORT i.e a traditional tabular grid and make use of information that is being communicated. I ask this because unfortunately some of our data partners doesn't have the infrastructure/sophistication to send as files or FTP it. But its very crucial that we make use of this data for daily reporting.
Any thought would be greatly appreciated as the solution that am looking for will save lot of man hours and increase accuracy.
@Raghu_s
This might not be a very elegant solution, but you could save emails as a html page and use RegEx to parse out data, like in this training video.
I am trying to use the Email OutlookInputTool. But this currently has limited options for choosing the Exchange Server Version. The mailbox I am accessing uses 14.3.XXX.XXXX which doesn't suit the exchange versions in my input tool. Do you have any suggestions?
where should I place the SqL query. Not sure if this is related to Alteryx version, but I donot see any place to right SqL query.
@MargaritaW - Please help! I have tried multiple ways but still can't access the linked Access Table
I have local admin rights on my company machine
Hi @Sagarika_k !
Sorry to hear you are not able to connect to your Access linked outlook table. Per Brandon answer to your post, you may want to try the Outlook input tool created by a community user rapugh, link here:
As Brandon mentioned, this is not developed by Alteryx and therefore is community supported.
Is there a direct way of accessing outlook and read email and attachment in alteryx workflow just like email send functionality in alteryx?
Hi @vaishalilambe17 .
Have you tried this tool created by our community user rapugh? https://community.alteryx.com/t5/Engine-Works-Blog/Outlook-Input-tool-Created-with-the-Alteryx-SDK/b...
Hi Margarita,
I am trying to input my access database file which reads the data from Share point . i tried the above mentioned similar steps that was suggested but it shows me an error.
Error: Input Data (38): Error opening table: Microsoft JET Database Engine: The Microsoft Jet database engine cannot find the input table or query 'SELECT * FROM DATABASE2'. Make sure it exists and that its name is spelled correctly.\3078 = -524420377.
I am using .mdb version. could you share the steps to resolve this?
Thanks
JB
Hi @Raghu_s
I am working on a similar requirement. Were you able to read table/grid data from email.
Can you please share the approach you followed.
@MargaritaW :I don't have an option to use the Outlook tool created by rpaugh.
Is there any other approach I can try
Thanks in advance
Nidhin
Does anyone know if there is a way to automate Access scraping outlook on a daily basis?
is there a way to access outlook emails from an alteryx server so you can schedule the workflow? or would this only work for manually running workflows locally?
i suppose the way around that would be the server needs to have a copy of outlook on it, and access to some kind of service account?
has anyone done this before, having a scheduled workflow on the server pick up attachments out of emails?
Whenever I try to connect to the accdb file and I put in the SQL query and click OK, Alteryx just closes. Anyone know why?
I've even tried hitting "Test Query" and Alteryx still closes
When I try to run the workflow pulling from my .accdb file that is linked to my outlook emails then I get a error.
Error: Designer x64: The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.
Does anyone know why?