Solved

Web form to Access Database that sends an email for each new entry

Posted on 2009-04-08
3
193 Views
Last Modified: 2013-12-24
I made a form using Frontpage 2003 that takes the contents of the form and puts it in an Access database on our server using Frontpage extensions. Simple stuff. That part works great.

What I want it to do is have an email sent to one specific address each time a new table record is entered into the database. This is all internal stuff, if that makes a difference. It's just for notification to the person that a new entry has been put into the database.

I figured this all out about six years ago at a previous job, and since then I have completely forgotten how I made it work! I also have Dreamweaver CS3, and can use either one for the solution. Seems like I remember having to put something within Access to make it work, but I just forgot the specifics. I'm using Access 2007.
0
Comment
Question by:William Fulks
3 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 250 total points
ID: 24122606
one way is to set up the confirmation page to go to a email send page then that will go to another finshed page... take a look at code hope it helps
<html>
 

<head>

<title>Sent Mail</title>

<meta name="Microsoft Theme" content="none, default">

<meta name="Microsoft Border" content="none, default">

</head>
 

<body leftmargin="24" marginwidth="24">
 

<%

subj =  "form completed"

smtpServer = "mailserver.co.uk"

comefrom = "webemail@mailserver.co.uk"
 

Dim ObjMail

Set ObjMail = Server.CreateObject("CDONTS.NewMail")

	ObjMail.To =  "toemailaddress"

	ObjMail.From = comefrom

	ObjMail.Subject = subj

	ObjMail.Body = "new edit completed - your message"

	ObjMail.Send

Set ObjMail = Nothing

%>
 

</body>
 

</html>

<%

Response.Redirect "https://where you want page to go?"

%>

Open in new window

0
 
LVL 14

Author Comment

by:William Fulks
ID: 24124490
I didn't think about that one. I'll give it a try when I get back to work on Monday, and I'll let you know. Thanks!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Data type mismatch in criteria expression 2 25
Help writing a query 6 71
combine ShipTo and BillTo Address 3 22
Importing and Dropping Table in Access 11 23
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now