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.
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.