Email the new record added to access table

[hazeleyre23]

Hi,

I have set up an email notification when a new record is added to the table, however I was wondering if it is possible to have the actual record emailed to me.



Currently I just get an email to say "New record added". Then I have to go into the table to find the new record.

Was hoping there is a smarter way of doing this.

thanks

[ranman256]

Docmd.sendobject ....

[hazeleyre23]

thanks, but can i get this command to only send the individual record or does it have to be the whole table?