Sending email messages with MS Access

[JACD]

Using an MS Access module (VBA Coding), I would like to send out an email message to certain people in the organization whenever a new record has been added to the table. Is this possible to code? If so, how do I begin; what procedures and functions will I need to use? How do I go about doing this?

Any help is greatly appreciated.

Thank you

 

[Craig0201]

JACD,

This depends!!!

Triggers don't exist in Access so it can't be done at table level....at form level, this is easy......either by using MAPI, a mail specific API or by the good old DoCmd.SendObject.....but it only works if you can ensure you're using forms.....

Craig