How do I send a Front Page Form in email AND to database?

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

Guest

I have created a form that sends my data to an Access database. What I need
to happen is when the user submits the form, an email needs to be sent to me
notifying me that a user has submitted a request.
 
Right click the form, select Form Properties, and in the dialog that opens enter an email address
you want the form results sent to.

it needs to be an email address associated with the domain.

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer
 
I can only select one option. I can either send to email or to a database.
It will not let me do both.
 
Great! Just what I was looking for. Thank you.

Thomas A. Rowe said:
The following is written for FP2000, but applies to FP2002 and FP2003

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Jennifer said:
I have created a form that sends my data to an Access database. What I need
to happen is when the user submits the form, an email needs to be sent to me
notifying me that a user has submitted a request.
Click to expand...
Click to expand...
 
Is this supposed to work with IIS6 on windows server 2003?
I followed the steps and ran across issue with CDONTS.NewMail so by making
this change:

'Set myCDONTSMail = CreateObject("CDONTS.NewMail")
Set myCDONTSMail = CreateObject("CDO.Message")

I get further but I am still getting this error message:

Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'Send'
/Emailtest.asp, line 189

Here is line 189:
myCDONTSMail.Send strFrom,strTo,strSubject,strBody

Please help Thanks
 
Hi I downloaded the instructions and I am not familiar with programming. Is
there just an easier way to email an alert that something was posted in the
database? I have over 65 questions on a form that is an application and
"Customizing the Database Page" seems that you have to insert every field in
the database? Then again it repeats for the fields for the body of the
message? I've tried working with this code and it just doesn't work.

Thomas A. Rowe said:
The following is written for FP2000, but applies to FP2002 and FP2003

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Jennifer said:
I have created a form that sends my data to an Access database. What I need
to happen is when the user submits the form, an email needs to be sent to me
notifying me that a user has submitted a request.
Click to expand...
Click to expand...
 
Requires you to learning how to write ASP/VBscript and work with whatever ASP Email component is
supported by your web host.

You will still have to insert each field on the form into the database, either by using the FP
database component or learning to hand code, etc.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


emom said:
Hi I downloaded the instructions and I am not familiar with programming. Is
there just an easier way to email an alert that something was posted in the
database? I have over 65 questions on a form that is an application and
"Customizing the Database Page" seems that you have to insert every field in
the database? Then again it repeats for the fields for the body of the
message? I've tried working with this code and it just doesn't work.

Thomas A. Rowe said:
The following is written for FP2000, but applies to FP2002 and FP2003

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================


Jennifer said:
I have created a form that sends my data to an Access database. What I need
to happen is when the user submits the form, an email needs to be sent to me
notifying me that a user has submitted a request.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top