Send Email everytime new record is added

[breadcrumbtrail]

Hi there!

I have a form that is used to enter data to a table. It is a form that was created by the Access wizard, so there is no command button to add the record to the table. Basically, what I'm trying to do, as the subject suggests, is that everytime a record gets added to the table through the form, I would like an automated email to be sent to a relavant party. Is there anyway to do this?

Many thanks,

- John

 

[Parker]

Hi there!

I have a form that is used to enter data to a table. It is a form that was created by the Access wizard, so there is no command button to add the record to the table. Basically, what I'm trying to do, as the subject suggests, is that everytime a record gets added to the table through the form, I would like an automated email to be sent to a relavant party. Is there anyway to do this?

Many thanks,

- John

Yes read up on emailing from access and fire the code on the 'on close' event for the form or create a command button on the form in design view and use the on click event to fire your code.

 

[o1110010]

.. It is a form that was created by the Access wizard, so there is no command button to add the record to the table. ... everytime a record gets added to the table through the form, I would like an automated email to be sent to a relavant party

You'll probably want to leave the wizard behind and implement VBA. You can solve by combining how to Navigate a Recordset and how to send email from VBA code. Refer to the two links to help you get started. (If the second is insufficient, you can search the forum with "send email" for other related threads.)

Good luck!