I'm trying to set up a MS Access table linked to an Outlook folder. I've been able to use the external data wizard to set up a linked table, but the table seems to only include subject lines and metadata. What I really need is the attachment from those emails. Is there any way to get attachments from an Outlook folder to import into an Access database as part of an external data source?
I'm trying to avoid having to open the inbox, save the attachment, and manually upload the attachment from the file location.