I want to implement the following function:

I created a form that is used to create and update information in a MS Access table. Suppose I pull out information from the table, update certain field, and then cick a "Save" or "Refresh" buttion - I want the system to generate an email message to the address that's also store in the Access database, and if the email was send succssfully, I will get a confirmation.

I have tried many ways and still can not get this done. Could anyone give some hints?

Thanks