Email Notification of New Records - possible ???

[Guest]

Is it possible to send an email notification from Access whenever a new
record hits the database?

We use Lotus Notes as opposed to Outlook but I believe this should still be
possible.

Essentially we have a database that we want to rollout to users, the DB
backend will reside on a server. When new records are added (by users) to
the database, we want a notification sent to IT department.

There doesn't need to be anything fancy with the email, just some text in
the subject heading would do to begin with....such as "New record added".

If anyone knows a way to do this, would you mind please sharing it with us.

 

[Allen Browne]

If your new records are added via forms in Access, you can use the
AfterInsert event procedure to fire off the email.

We generally use SendObject to send the email message. If Lotus Notes is
MAPI compliant, that should work. If not, Tony Toews has an email FAQ at:
http://www.granite.ab.ca/access/email.htm

If your record are not entered through the forms (e.g. directly into table,
via an Append query, ...) you will not be able to achieve this if the data
is stored in JET (Access), as it does not have triggers.