Hi Everyone,

I have a split database where users fill a form to update update a table in access 2013 database. What I would ideally like to achieve is to send an email once a form has been submitted. The email body should include First Name and Last Name fields within the form. I have tried to use the EMailDatabaseObject but this sends all the forms that have been used whereas I only want to send the details of one active form that has just been updated.
I have tried to set email at table level 'After record insert' but this prompts a windows security message which means I have to press 'ok to send' therefore inefficient if this is to be automatic

Does anyone have any ideas how I could achieve this? Just a simple email alert with 2 field details (First Name and Last Name) in the body of email.

Many thanks