Send Email when new record is added

[NewAccessDeveloper]

I am a newbie and I need to know how to automatically send an outlook email
when a new record has been added to a Access 2007 database...

The more specific the instructions the better; like the code and where you
place it would be great.

Thanks for your help in advance.

 

[Stuart McCall]

I am a newbie and I need to know how to automatically send an outlook email
when a new record has been added to a Access 2007 database...

The more specific the instructions the better; like the code and where you
place it would be great.

Thanks for your help in advance.

You will find complete instructions on how to code this in Access help.
Search for the SendObject command. As to where to place the code, use your
form's AfterInsert event, which is fired when a new record is added via the
form.

 

[NewAccessDeveloper]

Thanks so much for your response. The owner of the 2007 database wants to get
a get a email message everytime a user adds a record or makes updates to the
database. I have tried to use a macros but that only sends an object (or
maybe its my inexperience). I am thinking it needs to be wriiten in VBA (like
something firing after an event?) but I dont know how. I am looking for an
automated email message.