Access using Outlook Email/Calendar Confined Data Export

Hello,

My organisation is attempting to transition away from paper in the coming year and I am brainstorming ways to streamline information management through our Access software.

With Access 365 can you please advise on a process for generating a semi automated email (preferably Outlook calendar invite) to an email contact? Similar to an Access Report, this email would include preselected (prepopulated) Table data including hyperlinks, and/or attached documents. Additionally, would there also be a means for the recipient to add information, attachments to the Access database in response?

Also, is there a means for Access to notify you once this new information has been added to the database?

Thank you,

Nathan