Passing Email Responses from Outlook to Access (1 Viewer)

[malxvc]

In an Access form, I have a command button that shoots out an email to a list of people with the voting option "Yes;No".

When the user casts their vote, their response comes into my inbox, and I manually record their response in the database.

Is there a way to have those email response results pass back into the Access database I'm working in?

 

[DJkarl]

Two ways I could see doing this.

Link your Inbox to Access and query the table for the responses, then update your results.

Or add VBA code into Outlook and have it scan and update Access when the forms are received.

 

[malxvc]

The only issue with linking the Inbox (shared, departmental mailbox) to the Access database is that the responses will be archived in a folder unique according to the response date in a "YYYYMM" format.

Establishing the link on the head folder does not capture all of the subfolders within, and in my case, the subfolders will be everchanging.

Would it be possible within VBA to establish a 'new' link to the mailbox subfolder specified by my date inputs in the Access form?

The folder hierarchy is as follows:
Mailbox\Retention\BusinessLine\201301\SalesRep

The voting responses are to be stored in the SalesRep folder

I'd like to avoid VBA in Outlook if at all possible