Email Notification

[drock99a]

Hello,

I was hoping someone could show me the basics on having Access sending out an email everytime a new entry has been added to a table My email is Outlook, not sure if this is helpful or not. I would like the email to state what was added to the table.

 

[Philem]

Hullo. This should not be too difficult. Hopefully, you have your data for new records entered through a form. If so, just chain some code to the "OK/Submit/Next Record" or whatever it is button on your form that fires the e-mail.

If you DON'T have a form to handle this... The other way I can think of at the moment would involve having a file change watcher set to your db, but not sure you could glean the data added.

HTH
P