Email Notification

  • Thread starter Thread starter denelson
  • Start date Start date
D

denelson

I have a Data Access Page in which users enter in information and it
gets stored to a DB. Easy. However I would like an email notification
just saying that the record has been added. I'm not an expert with
Access but I know enough I suppose. Any help would be greatly
appreciated.
 
try something like the following if you are within access - which I am
not sure you really are within the data access page.

DoCmd.SendObject , , , "(e-mail address removed)",
"(e-mail address removed)", , "Subject message", "message text"

If you cannot issue that command from within the page then you would
have to have a field within the record that could be used in a query to
send info to user. I guess the other question is - do you know the
email address of the user. and if you use a field to query then you
will still need to know who put this particular record in the table.

Ron
 
Thanks for the info. however this looks like VB code and I need the
HTML code becuase I'm creating a webpage using the data access page, or
more specific the pages object in Access. I have a submit button and
when I open the view code for that and the commands are all on the left
(on click, onclick javascript, onupdate...etc) and I just want to be
able to have an email sent to me when the user hits the submit
button...
 
Your analysis is correct on both counts: It is VBA and useless for your
purpose and situation.

I would check in a HTML group for how they send email. I have done some
html and sent email via an outside service but it was associated with
the onclick event of a button. There are various services available for
sending email as you desire, in fact check with your ISP and/or IT
department, they may be able to point you to one that they prefer
especially if this is an intranet situation.

You probably have a save button involved that it could be triggered
from. I have the code at home. I will try to get it tonight and post
it. It has been a couple of years since it was set up so you will have
to see if the service is still available and/or will give you what you
want.

Ron
 
Here is the basic code. All the instructions etc were at the site
www.response-o-matic.com.

The site is still up. You can check it out at that site above.


<BODY BGCOLOR="#FFFFFF">

<FORM action="http://www.response-o-matic.com/cgi-bin/rom.pl"
method="POST">

<H1><CENTER>&nbsp;</CENTER></H1>

<H1><CENTER><FONT COLOR="#000000">Thanks for visiting my site!</FONT>

</CENTER></H1>

<H3><CENTER>

<INPUT TYPE="hidden" NAME="your_email_address"
VALUE="(e-mail address removed)">

<INPUT TYPE="hidden" NAME="your_name" VALUE="Tom and Lucy">

<INPUT TYPE="hidden" NAME="email_subject_line" VALUE="Questions and
Comments.....">

<INPUT TYPE="hidden" NAME="required_fields" VALUE="your_email_address">

<INPUT TYPE="hidden" NAME="thank_you_title" VALUE="Thanks! We
appreciate your comments">

<INPUT TYPE="hidden" NAME="return_link_url"
VALUE="http://www.angelfire.com/jazz/tldistributing/tld-index.html">

<INPUT TYPE="hidden" NAME="return_link_name" VALUE="Back to the Home
Page">

<INPUT TYPE="hidden" NAME="background_color" VALUE="#C0C0C0">

<INPUT TYPE="hidden" NAME="text_color" VALUE="#000000">

<INPUT TYPE="hidden" NAME="link_color" VALUE="#0000FF">

<INPUT TYPE="hidden" NAME="visited_link_color" VALUE="#8000FF">

<INPUT TYPE="hidden" NAME="active_link_color" VALUE="#0000FF">

</CENTER></H3>

<H3><CENTER>Your comments are appreciated!</CENTER></H3>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Email Notification 17
Go to a specific record on a form from the same form 3
email notification when new DB record created - possible?? 5
Please help direct me to the right forum 5
query; add records notification 1
Emailing Data 1
New appointment email notification goes to wrong email 0

Back
Top