Data collection by email MS Access Office 365

[jpardi]

Good day,
I searched Access help and found that only 2007 & 2010 listed. Is it available with Office 365?

Many years ago I used this function. An email from Access was sent with a form to complete. Once the email was returned, the data entered in the form updated the table.

It's been many years and I am not an Access expert, no VBA, simple macros etc...but I cannot remember how I set this up, but it did work!

Thank you for your help

 

[Micron]

The form was an attachment? If so, what type, Word? You might be referring to Mail Merge, or perhaps this

Add the data collected through e-mails to your Access database - Microsoft Support

support.microsoft.com

I suspect that it's still supported in 365 but I don't know. Or search by using "ms access get email data into 365 access". Your approach will depend on whether or not you're getting the data from attachments or the email body. Those links might not help if the data is in an Excel file.

 

[jpardi]

The form was an attachment? If so, what type, Word? You might be referring to Mail Merge, or perhaps this

Add the data collected through e-mails to your Access database - Microsoft Support

support.microsoft.com

I suspect that it's still supported in 365 but I don't know. Or search by using "ms access get email data into 365 access". Your approach will depend on whether or not you're getting the data from attachments or the email body. Those links might not help if the data is in an Excel file.

It was Data collected by email, and we may have been using 2007 version at the time. But now, Office 365. I googled, looked on Microsoft, looked at Access help.

If I remember correctly, it was around 2011 or later, and the entire email was generated within Access, sent to one recipient that completed the form and once she replied, I think I had to accept, and the table was updated.