Email and database help

  • Thread starter Thread starter Paul M
  • Start date Start date
P

Paul M

Hi
I have a form which sends its contents to an access database.This was
created by the right click on the form options create database method. this
works fine.
How can I have the results sent to the database and an additional email
which simply instructs the client that there has been another record added.
I don't need to pass on the form fields in the email
Thanks
Paul M
 
See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
Applies to FP2000 and up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Hi
I have put this code from the microsoft article in a page I hoped it would
send me an email telling me a new entry had been added to my database the
database added to But I dont recieve an email
Help
Paul M

<%
Dim myCDONTSMail
Dim strFrom
Dim strTo
Dim strSubject
strFrom = "(e-mail address removed)"
strTo = "(e-mail address removed)"
strSubject = "New entry"
Set myCDONTSMail = CreateObject("CDONTS.NewMail")
myCDONTSMail.Send strFrom,strTo,strSubject
Set myCDONTSMail = Nothing
%>

Thomas A. Rowe said:
See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
Applies to FP2000 and up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Paul M said:
Hi
I have a form which sends its contents to an access database.This was
created by the right click on the form options create database method.
this works fine.
How can I have the results sent to the database and an additional email
which simply instructs the client that there has been another record
added. I don't need to pass on the form fields in the email
Thanks
Paul M
Click to expand...
Click to expand...
 
Does your host support CDONTS?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Paul M said:
Hi
I have put this code from the microsoft article in a page I hoped it would send me an email
telling me a new entry had been added to my database the database added to But I dont recieve an
email
Help
Paul M

<%
Dim myCDONTSMail
Dim strFrom
Dim strTo
Dim strSubject
strFrom = "(e-mail address removed)"
strTo = "(e-mail address removed)"
strSubject = "New entry"
Set myCDONTSMail = CreateObject("CDONTS.NewMail")
myCDONTSMail.Send strFrom,strTo,strSubject
Set myCDONTSMail = Nothing
%>

Thomas A. Rowe said:
See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
Applies to FP2000 and up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Paul M said:
Hi
I have a form which sends its contents to an access database.This was created by the right
click on the form options create database method. this works fine.
How can I have the results sent to the database and an additional email which simply instructs
the client that there has been another record added. I don't need to pass on the form fields in
the email
Thanks
Paul M
Click to expand...
Click to expand...
Click to expand...
 
Hi Thomas
Yes, I know this because I use some script for emailing a lost password
Paul M
Thomas A. Rowe said:
Does your host support CDONTS?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Paul M said:
Hi
I have put this code from the microsoft article in a page I hoped it
would send me an email telling me a new entry had been added to my
database the database added to But I dont recieve an email
Help
Paul M

<%
Dim myCDONTSMail
Dim strFrom
Dim strTo
Dim strSubject
strFrom = "(e-mail address removed)"
strTo = "(e-mail address removed)"
strSubject = "New entry"
Set myCDONTSMail = CreateObject("CDONTS.NewMail")
myCDONTSMail.Send strFrom,strTo,strSubject
Set myCDONTSMail = Nothing
%>

Thomas A. Rowe said:
See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
Applies to FP2000 and up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Hi
I have a form which sends its contents to an access database.This was
created by the right click on the form options create database method.
this works fine.
How can I have the results sent to the database and an additional email
which simply instructs the client that there has been another record
added. I don't need to pass on the form fields in the email
Thanks
Paul M
Click to expand...
Click to expand...
Click to expand...
 
Then copy the same section of code you are currently using to email lost password to this script.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Paul M said:
Hi Thomas
Yes, I know this because I use some script for emailing a lost password
Paul M
Thomas A. Rowe said:
Does your host support CDONTS?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Paul M said:
Hi
I have put this code from the microsoft article in a page I hoped it would send me an email
telling me a new entry had been added to my database the database added to But I dont recieve
an email
Help
Paul M

<%
Dim myCDONTSMail
Dim strFrom
Dim strTo
Dim strSubject
strFrom = "(e-mail address removed)"
strTo = "(e-mail address removed)"
strSubject = "New entry"
Set myCDONTSMail = CreateObject("CDONTS.NewMail")
myCDONTSMail.Send strFrom,strTo,strSubject
Set myCDONTSMail = Nothing
%>

See:
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q275251
Applies to FP2000 and up.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

Hi
I have a form which sends its contents to an access database.This was created by the right
click on the form options create database method. this works fine.
How can I have the results sent to the database and an additional email which simply instructs
the client that there has been another record added. I don't need to pass on the form fields
in the email
Thanks
Paul M
Click to expand...
Click to expand...
Click to expand...
 
Back
Top