Collect data by using e-mail messages access 2016

[Mick99]

Hi all, i know that this functionality was removed from 2013 and onwards. I was wondering if there is any VBA code that replicates this. I have a table that contains a list of records that are specific to the email receiver and when emailed and that email has been updated than i need to go back and update the RS. Any ideas or suggestions as always would be greatly appreciated.



Cheers Mick

[davegri]

I have a table that contains a list of records that are specific to the email receiver and when emailed and that email has been updated than i need to go back and update the RS.

That is a confusing jumble of words statement. Can you clear it up?

[Mick99]

Sorry, i have a table called obligations and in this table i have a field called"status" that is a checkbox for either yes or no response. I have a second field called "Comments" that allows for an explanation as to why something has or has not be checked as complete. The third field called "email" contains the email address that the response is required from. What i need to do is trigger an email to that email and have them presented with the checkbox and field so they can make the updates. Upon them replying to the questions than the answers would update again the originating fields. Hope this makes more sense.

Cheers

[davegri]

I don't think you are going to be able to collect the data that you want without the removed functionality. This would require VBA to email the recipients and VBA to import the responses and parse the responses into a meaningful set of data items to insert into a table. I would never attempt this myself if this was the only way to reach your objective. If anyone else has an alternative simpler solution, I'd be interested in seeing it.