Access Automatically Send a notification email once a record is added

Dec 4, 2020
Reaction score
I am new to Access. Any help would be greatly appreciated.

I have a created a helpdesk service request DB.
The user enters the pertinent info into a form. At the button of the form I have placed a command button with an On Click embedded macro that Saves and Closes. I would like to incorporate into that same button the task to automatically send a notification email to our helpdesk email address. I would imagine that the send email command would have to be place in between the SaveRecord and CloseWindow commands in the macro.

I'd like the email to included certain fields from the record that was just entered and saved; ID, Dept, User name, Issue, and Problem Description.

Record table: tblTickets
Record entry form: frmITTickets
Command Button: cbtSaveClose

Thank you in advance for any help you may provide.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question