Connecting to Outlook Emails - Linked MS Access Table

[Jon-Knepper]

Hey Community!

I need some help.  I have looked through various community articles, but seem to be striking out.  I am trying to connect to outlook to be able to read incoming emails.  Ultimately I want this to be automated so that I can leverage these emails as a trigger to run other various workflows.  I have MS office 365 and used MS access to create a linked table that pulls in emails from a specific email box.  When I add this input into Alteryx I am unable to see the table in the list.  When I attempt to pull it via SQL it gives me an error that the query is wrong.  I have tested just putting in a simple table and I am able to see that table in my input.

I was able to do this in the past, but I wonder if moving to office 365 has changed being able to do this going forward.

Has anyone else had success with this and be able to help?

[Jon-Knepper · Accepted solution]

I solved it.  It seemed to be a first time sync issue.  All other times accessing it I have been able to see all of the folders in my inbox.  

[swestfield]

Hi Jon - can you please share your solution as I too am encountering the same challenge. When creating a standard table in access, the Alteryx Data Input Source lists the available Tables but does not for an .accb for Linked Tables. Like you I want my data to remain dynamic as the contents of my mailbox changes.

Regards

[Jayan_alteryx]

Hi Jon..I am also facing the same and hence need your solution for this