email notification when new DB record created - possible??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is it possible to have access send an email notification to a designated
email address, whenever a new record hits the database ?

Essentially we want users to submit there own requests for support, when a
new record enters the database we would like to trigger an email notification
to the IT department to advice of "new record created".

Doesn't need to be fancy, it just needs to work. We use Lotus Notes if that
makes any difference at all. We also have access to SMTP servers for routing
mail.
 
Access does not support triggers - SQL Server does. There is no way to do
it from the table level, but if you have a form that they are entering the
data through you could have the email sent from the form when they
submit/save the record.

--Steve Huff
 
Steve, thanks for the feedback.

Can you explain more about your suggestion to send an email from the form
please? The users essentially will use a form to add records to the DB.
 
You mentioned you where using Lotus Notes which I've never used so I can't be
for sure how things will work -- but when using Microsoft Outlook you can't
send an email without a prompt to the user telling them that a program is
trying to send an email on there behalf (there attempt to help get rid of
email viruses). There is a program that you can purchase that will allow you
to get around this, but I can't think of the name plus you are not using
Microsoft Outlook you are using Lotus notes.

Would it be acceptable for an email to automatically pop up for them to
send? If so you can use a hyperlink to do it. Create a button on the form
to save the record and call it cmdSave and then make it the hyperlink address
mailto: and in code say this:

After the code to save the record put in this:

cmdSave.HyperlinkAddress = "mailto:[email protected]?subject=test
subject&body=test body"

that will pop open an already filled out email ready for them to send. If
you want to do it behind the scenes, which I think you do you will have to
look up code for controlling Lotus Notes via Automation or re-post a quesiton
on how to send an emial from Acces via Lotus Notes behind the scences - sorry
I don't know how to do that as I don't use Lotus Notes.

--Steve Huff
 
Craig said:
We use Lotus Notes if that
makes any difference at all. We also have access to SMTP servers for routing
mail.
Click to expand...

To follow up on Steve's posting there are some Lotus Notes solutions
at the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Ok I have a similar issue where what I want to do is have the user save the
record and then click on a hyperlink to send all the information from the
record to a whomever via outlook and have the email body be the information
from that record and the subject of the email be a static sentance plus the
information from one field of that record. Additionally my user's are using
an html front end instead of actually opening the access database. What would
i need to modify from the previously mentioned code to be able to do this?
Additionally is there a way to allow them to search through all records in
the database for a particular peice of information in any field or
combination of fields from that html page instead of from an access form. I
know we are using at least access 200 but it may be a more recent version if
that helps any.
 
Back
Top