Generate email when I click button?

When I click "save" after adding a new record (which contains, among other
fields, the person's email address), I want an email to automatically be sent
to that person (at the email that is in the field of that record). How can I
do this?

Thanks so much, it really means so much to me!!!

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

McKirahan
Thu Oct 11 14:08:32 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:798bc3f05f9b3@uwe...
> When I click "save" after adding a new record (which contains, among other
> fields, the person's email address), I want an email to automatically be
sent
> to that person (at the email that is in the field of that record). How can
I
> do this?

What does your Web host support?
Perhaps, CDO.Message or ASPMail.

majahops
Thu Oct 11 14:59:10 PDT 2007

First off, thank you SO much for responding - it mean's a lot to me - i've
been trying to get this done forever.

So I have godaddy.com. When I look up what they support, I get the following:


CDO.MESSAGE
CDONTS.NewMail

I'm assuming that means that godaddy.com supports CDO.Message.

Thank you so so so so so much again. My heart skipped a beat when I saw that
somebody had finally [at least tried] to answer my cries for help.

Tim


McKirahan wrote:
>> When I click "save" after adding a new record (which contains, among other
>> fields, the person's email address), I want an email to automatically be sent
>> to that person (at the email that is in the field of that record). How can I
>> do this?
>
>What does your Web host support?
>Perhaps, CDO.Message or ASPMail.

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

McKirahan
Thu Oct 11 16:03:53 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:798cc27bb482e@uwe...
> First off, thank you SO much for responding - it mean's a lot to me - i've
> been trying to get this done forever.
>
> So I have godaddy.com. When I look up what they support, I get the
following:
>
>
> CDO.MESSAGE
> CDONTS.NewMail
>
> I'm assuming that means that godaddy.com supports CDO.Message.

[snip]

Try this; watch for word-wrap.

The Response.Write() statement invokes the function;
modify it to suit your needs. Just call the function by
passing in 3 parms: email address, subject, and body.

The value of "cHST" (Host) is what GoDaddy requires.
The value of "cFRM" (From) is your email address.

Suucess/failure reporting has been commented out as
you may want to log the results rather than display them.

<%@ Language="VBScript" %>
<% Option Explicit

Response.Write("Email = " & Email("news@mckirahan.com","Test","Test!"))

Function Email(sAddr,sSubj,sBody)
Email = False
On Error Resume Next
'*
'* Declare Constants
'*
Const cCDO = "http://schemas.microsoft.com/cdo/configuration/"
Const cHST = "relay-hosting.secureserver.net"
Const cFRM = "postmaster@{your~domain.com}"
'*
'* Send Email
'*
Dim objCFG
Set objCFG = Server.CreateObject("CDO.Configuration")
objCFG.Fields.Item(cCDO & "sendusing") = 2
objCFG.Fields.Item(cCDO & "smtpserver") = cHST
objCFG.Fields.Item(cCDO & "smtpserverport") = 25
objCFG.Fields.Update
Dim objCDO
Set objCDO = Server.CreateObject("CDO.Message")
objCDO.From = cFRM
objCDO.To = sAddr
'objCDO.BCC = ""
'objCDO.CC = ""
objCDO.Subject = sSubj
objCDO.TextBody = sBody
'objCDO.HTMLBody = sBody
'objCDO.AddAttachment = ""
objCDO.Configuration = objCFG
objCDO.Send
' If Err = 0 Then
' Response.Write("<br><br><b>E-mail has been sent.</b>")
' Else
' Response.Write("<br><b>Sub Email()</b>")
' Response.Write("<br><b>CDO Failed:</b> " & Err.Description)
' Response.Write("<br><b>CDO 'Addr':</b> " & sAddr)
' Response.Write("<br><b>CDO 'Subj':</b> " & sSubj)
' Response.Write("<br><b>CDO 'Body':</b> " & sBody)
' End If
Set objCDO = Nothing
Set objCFG = Nothing
'*
'* Return
'*
On Error GoTo 0
Email = True
End Function
%>

majahops
Thu Oct 11 16:12:12 PDT 2007

McKirahan,

Before I do this, where do I put all of this text? That has been one of the
things that is unclear to me. Do I put it next to the like where the save-
button is in the html, or what? Thanks so much again!

McKirahan wrote:
>> First off, thank you SO much for responding - it mean's a lot to me - i've
>> been trying to get this done forever.
>[quoted text clipped - 5 lines]
>>
>> I'm assuming that means that godaddy.com supports CDO.Message.
>
>[snip]
>
>Try this; watch for word-wrap.
>
>The Response.Write() statement invokes the function;
>modify it to suit your needs. Just call the function by
>passing in 3 parms: email address, subject, and body.
>
>The value of "cHST" (Host) is what GoDaddy requires.
>The value of "cFRM" (From) is your email address.
>
>Suucess/failure reporting has been commented out as
>you may want to log the results rather than display them.
>
><%@ Language="VBScript" %>
><% Option Explicit
>
>Response.Write("Email = " & Email("news@mckirahan.com","Test","Test!"))
>
>Function Email(sAddr,sSubj,sBody)
> Email = False
> On Error Resume Next
> '*
> '* Declare Constants
> '*
> Const cCDO = "http://schemas.microsoft.com/cdo/configuration/"
> Const cHST = "relay-hosting.secureserver.net"
> Const cFRM = "postmaster@{your~domain.com}"
> '*
> '* Send Email
> '*
> Dim objCFG
> Set objCFG = Server.CreateObject("CDO.Configuration")
> objCFG.Fields.Item(cCDO & "sendusing") = 2
> objCFG.Fields.Item(cCDO & "smtpserver") = cHST
> objCFG.Fields.Item(cCDO & "smtpserverport") = 25
> objCFG.Fields.Update
> Dim objCDO
> Set objCDO = Server.CreateObject("CDO.Message")
> objCDO.From = cFRM
> objCDO.To = sAddr
> 'objCDO.BCC = ""
> 'objCDO.CC = ""
> objCDO.Subject = sSubj
> objCDO.TextBody = sBody
> 'objCDO.HTMLBody = sBody
> 'objCDO.AddAttachment = ""
> objCDO.Configuration = objCFG
> objCDO.Send
>' If Err = 0 Then
>' Response.Write("<br><br><b>E-mail has been sent.</b>")
>' Else
>' Response.Write("<br><b>Sub Email()</b>")
>' Response.Write("<br><b>CDO Failed:</b> " & Err.Description)
>' Response.Write("<br><b>CDO 'Addr':</b> " & sAddr)
>' Response.Write("<br><b>CDO 'Subj':</b> " & sSubj)
>' Response.Write("<br><b>CDO 'Body':</b> " & sBody)
>' End If
> Set objCDO = Nothing
> Set objCFG = Nothing
> '*
> '* Return
> '*
> On Error GoTo 0
> Email = True
>End Function
>%>

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

majahops
Thu Oct 11 16:15:24 PDT 2007

Here is the area of html around the save button (plus some more)...where
would i put the part you gave me into this? Thanks so much again!!!

<TD class=shade style="BACKGROUND-COLOR: #e6e6fa" width=172>
<P align=right>SPID</P></TD>
<TD width=240>{build_edit_control field="SPID" mode="add" value=
$value_SPID} </TD></TR>
<TR height=50>
<TD style="BACKGROUND-COLOR: #e6e6fa" align=middle width=414
colSpan=2><INPUT class=button id=submit1 type=submit value=Save name=submit1>

<INPUT class=button type=reset value=Reset> <input type=hidden name="a"
value="added"></TD></TR></FORM><!-- legend -->
<TR height=50>
<TD style="BACKGROUND-COLOR: #e6e6fa" align=left width=414 colSpan=2>
<HR width=400 noShade SIZE=1>
<BR><IMG src="images/icon_required.gif"> - Required field
</TD></TR></TBODY></TABLE>{include_if_exists file="include/footer.asp"} {
$linkdata}<script>SetToFirstControl();</script></BODY></HTML>


McKirahan wrote:
>> First off, thank you SO much for responding - it mean's a lot to me - i've
>> been trying to get this done forever.
>[quoted text clipped - 5 lines]
>>
>> I'm assuming that means that godaddy.com supports CDO.Message.
>
>[snip]
>
>Try this; watch for word-wrap.
>
>The Response.Write() statement invokes the function;
>modify it to suit your needs. Just call the function by
>passing in 3 parms: email address, subject, and body.
>
>The value of "cHST" (Host) is what GoDaddy requires.
>The value of "cFRM" (From) is your email address.
>
>Suucess/failure reporting has been commented out as
>you may want to log the results rather than display them.
>
><%@ Language="VBScript" %>
><% Option Explicit
>
>Response.Write("Email = " & Email("news@mckirahan.com","Test","Test!"))
>
>Function Email(sAddr,sSubj,sBody)
> Email = False
> On Error Resume Next
> '*
> '* Declare Constants
> '*
> Const cCDO = "http://schemas.microsoft.com/cdo/configuration/"
> Const cHST = "relay-hosting.secureserver.net"
> Const cFRM = "postmaster@{your~domain.com}"
> '*
> '* Send Email
> '*
> Dim objCFG
> Set objCFG = Server.CreateObject("CDO.Configuration")
> objCFG.Fields.Item(cCDO & "sendusing") = 2
> objCFG.Fields.Item(cCDO & "smtpserver") = cHST
> objCFG.Fields.Item(cCDO & "smtpserverport") = 25
> objCFG.Fields.Update
> Dim objCDO
> Set objCDO = Server.CreateObject("CDO.Message")
> objCDO.From = cFRM
> objCDO.To = sAddr
> 'objCDO.BCC = ""
> 'objCDO.CC = ""
> objCDO.Subject = sSubj
> objCDO.TextBody = sBody
> 'objCDO.HTMLBody = sBody
> 'objCDO.AddAttachment = ""
> objCDO.Configuration = objCFG
> objCDO.Send
>' If Err = 0 Then
>' Response.Write("<br><br><b>E-mail has been sent.</b>")
>' Else
>' Response.Write("<br><b>Sub Email()</b>")
>' Response.Write("<br><b>CDO Failed:</b> " & Err.Description)
>' Response.Write("<br><b>CDO 'Addr':</b> " & sAddr)
>' Response.Write("<br><b>CDO 'Subj':</b> " & sSubj)
>' Response.Write("<br><b>CDO 'Body':</b> " & sBody)
>' End If
> Set objCDO = Nothing
> Set objCFG = Nothing
> '*
> '* Return
> '*
> On Error GoTo 0
> Email = True
>End Function
>%>

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

McKirahan
Thu Oct 11 19:42:58 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:798d6cf71f578@uwe...
> Here is the area of html around the save button (plus some more)...where
> would i put the part you gave me into this? Thanks so much again!!!
>
> <TD class=shade style="BACKGROUND-COLOR: #e6e6fa" width=172>
> <P align=right>SPID</P></TD>
> <TD width=240>{build_edit_control field="SPID" mode="add" value=
> $value_SPID} </TD></TR>
> <TR height=50>
> <TD style="BACKGROUND-COLOR: #e6e6fa" align=middle width=414
> colSpan=2><INPUT class=button id=submit1 type=submit value=Save
name=submit1>
>
> <INPUT class=button type=reset value=Reset> <input type=hidden name="a"
> value="added"></TD></TR></FORM><!-- legend -->
> <TR height=50>
> <TD style="BACKGROUND-COLOR: #e6e6fa" align=left width=414 colSpan=2>
> <HR width=400 noShade SIZE=1>
> <BR><IMG src="images/icon_required.gif"> - Required field
> </TD></TR></TBODY></TABLE>{include_if_exists file="include/footer.asp"} {
> $linkdata}<script>SetToFirstControl();</script></BODY></HTML>

Where's your ASP code?

McKirahan
Thu Oct 11 19:43:01 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:798d65d0832f8@uwe...
> McKirahan,
>
> Before I do this, where do I put all of this text? That has been one of
the
> things that is unclear to me. Do I put it next to the like where the save-
> button is in the html, or what? Thanks so much again!

[snip]

You're original post included the following statement:
>When I click "save" after adding a new record ...

What is the ASP logic behind your save button.

After the "save" call the "Email()" function.
You do know something about ASP don't you?
All ASP code is between <% and %> tags unless it's "included".

McKirahan
Fri Oct 12 05:56:40 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:798f55780afd8@uwe...
> Sorry about that, here is the asp for that "Add doctor" page: Thank you
again!

[snip 2400+ lines!]

> McKirahan wrote:
> >> Here is the area of html around the save button (plus some
more)...where
> >> would i put the part you gave me into this? Thanks so much again!!!
> >
> >Where's your ASP code?

Insert the Function Email() after your ASP code but within <% and %>.

After you save the Doctor then call the "Email()" function as I
showed you in the Response.Write() statement; for example:

If Email("news@mckirahan.com","Test","Test!")) Then
' success
Else
' failure
End If

How do you save the Doctor?
I don't see any database code.
What database are you using?
Is the code within an "include"?

majahops
Fri Oct 12 08:53:52 PDT 2007

Is this what you mean? Thanks so much by the way.

<TD class=shade style="BACKGROUND-COLOR: #e6e6fa" width=172>
<P align=right>SPID</P></TD>

<TD width=240>{build_edit_control field="SPID" mode="add" value=
$value_SPID} </TD></TR>
<TR height=50>
<TD style="BACKGROUND-COLOR: #e6e6fa" align=middle width=414
colSpan=2><INPUT class=button id=submit1 type=submit value=Save name=submit1>

<INPUT class=button type=reset value=Reset> <input type=hidden name="a"
value="added"></TD></TR></FORM><!-- legend -->
<TR height=50>
<TD style="BACKGROUND-COLOR: #e6e6fa" align=left width=414 colSpan=2>
<HR width=400 noShade SIZE=1>
<BR><IMG src="images/icon_required.gif"> - Required field

</TD></TR></TBODY></TABLE>{include_if_exists file="include/footer.asp"} {
$linkdata}<script>SetToFirstControl();</script></BODY></HTML>


McKirahan wrote:
>> Sorry about that, here is the asp for that "Add doctor" page: Thank you again!
>
>[snip 2400+ lines!]
>
>> >> Here is the area of html around the save button (plus some more)...where
>> >> would i put the part you gave me into this? Thanks so much again!!!
>> >
>> >Where's your ASP code?
>
>Insert the Function Email() after your ASP code but within <% and %>.
>
>After you save the Doctor then call the "Email()" function as I
>showed you in the Response.Write() statement; for example:
>
>If Email("news@mckirahan.com","Test","Test!")) Then
>' success
>Else
>' failure
>End If
>
>How do you save the Doctor?
>I don't see any database code.
>What database are you using?
>Is the code within an "include"?

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

majahops
Fri Oct 12 12:22:52 PDT 2007

McKirahan, would it be possible to email you directly?

McKirahan wrote:
>> Sorry about that, here is the asp for that "Add doctor" page: Thank you again!
>
>[snip 2400+ lines!]
>
>> >> Here is the area of html around the save button (plus some more)...where
>> >> would i put the part you gave me into this? Thanks so much again!!!
>> >
>> >Where's your ASP code?
>
>Insert the Function Email() after your ASP code but within <% and %>.
>
>After you save the Doctor then call the "Email()" function as I
>showed you in the Response.Write() statement; for example:
>
>If Email("news@mckirahan.com","Test","Test!")) Then
>' success
>Else
>' failure
>End If
>
>How do you save the Doctor?
>I don't see any database code.
>What database are you using?
>Is the code within an "include"?

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

McKirahan
Fri Oct 12 15:51:12 PDT 2007


"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:799624a4718c6@uwe...
> Is this what you mean? Thanks so much by the way.

[snip]

No.

McKirahan
Fri Oct 12 15:51:14 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:7997f7b5ea12a@uwe...
> McKirahan, would it be possible to email you directly?

[snip]

Let's keep it in the newsgroup so others may benefit.

majahops
Fri Oct 12 16:48:40 PDT 2007

Thanks for trying to help, but it doesn't seem like anybody knows how to do
this when it comes down to it. I do sincerely appreciate your help though.

Tim

McKirahan wrote:
>> McKirahan, would it be possible to email you directly?
>
>[snip]
>
>Let's keep it in the newsgroup so others may benefit.

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

majahops
Fri Oct 12 16:48:51 PDT 2007

And what do you mean by "snip"?

majahops wrote:
>Thanks for trying to help, but it doesn't seem like anybody knows how to do
>this when it comes down to it. I do sincerely appreciate your help though.
>
>Tim
>
>>> McKirahan, would it be possible to email you directly?
>>
>>[snip]
>>
>>Let's keep it in the newsgroup so others may benefit.

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

McKirahan
Fri Oct 12 20:04:42 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:799a4a59b76cd@uwe...
> And what do you mean by "snip"?

"[snip]" indicates that lines were removed from a previous post
to avoid clutter; that is, to keep the size of the message down
as well as to allow the most relevant points to be readable

> majahops wrote:
> >Thanks for trying to help, but it doesn't seem like anybody knows how to
do
> >this when it comes down to it. I do sincerely appreciate your help
though.

The "anybody" you refer to is evidently me and I do know how to
sedn email from within ASP using GoDaddy.

You haven't answered my questions about how use use ASP to
save a new Doctor so the task of helping you is difficult.

Good luck.

> >>> McKirahan, would it be possible to email you directly?
> >>
> >>[snip]
> >>
> >>Let's keep it in the newsgroup so others may benefit.

majahops
Fri Oct 12 20:10:15 PDT 2007

I didn't mean to be rude, im just desperate. Can I attach/send all of my asp
and aspx files relating to this so you can see? Im sure you'll know which one
it is within a few seconds.

It'd mean a lot. thanks

Tim

McKirahan wrote:
>> And what do you mean by "snip"?
>
>"[snip]" indicates that lines were removed from a previous post
>to avoid clutter; that is, to keep the size of the message down
>as well as to allow the most relevant points to be readable
>
>> >Thanks for trying to help, but it doesn't seem like anybody knows how to do
>> >this when it comes down to it. I do sincerely appreciate your help though.
>
>The "anybody" you refer to is evidently me and I do know how to
>sedn email from within ASP using GoDaddy.
>
>You haven't answered my questions about how use use ASP to
>save a new Doctor so the task of helping you is difficult.
>
>Good luck.
>
>> >>> McKirahan, would it be possible to email you directly?
>> >>
>> >>[snip]
>> >>
>> >>Let's keep it in the newsgroup so others may benefit.

--
Message posted via http://www.webmasterkb.com

McKirahan
Sat Oct 13 07:36:58 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:799c0c90ad6f3@uwe...
> I didn't mean to be rude, im just desperate. Can I attach/send all of my
asp
> and aspx files relating to this so you can see? Im sure you'll know which
one
> it is within a few seconds.
>
> It'd mean a lot. thanks

[snip]

Is your site using ASP (.asp) or ASP.NET (.aspx) pages?

Don't send them! If you are a developer then you should be
able to figure out where my function goes and how it works.

If you're not a developer what are you doing maintaining code!

majahops
Sat Oct 13 10:13:02 PDT 2007

ASP.NET. Why, is this the wrong place for that?

McKirahan wrote:
>> I didn't mean to be rude, im just desperate. Can I attach/send all of my asp
>> and aspx files relating to this so you can see? Im sure you'll know which one
>> it is within a few seconds.
>>
>> It'd mean a lot. thanks
>
>[snip]
>
>Is your site using ASP (.asp) or ASP.NET (.aspx) pages?
>
>Don't send them! If you are a developer then you should be
>able to figure out where my function goes and how it works.
>
>If you're not a developer what are you doing maintaining code!

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

majahops
Sat Oct 13 11:23:23 PDT 2007

Look McKirahan,

First off, no I am not a developer. I am a clinical oncologist (cancer MD)
who is part of a small group of physicians that are trying to organize a
volunteer physician-based program that will offer free screening to the
uninsured and underinsured populations of california for prostate, breast and
other reproductive cancers.

I volunteered to work on the website (in retrospect, probably a bad idea, but
I promised I would and I need to make good on it). A program called ASPRunner
Pro was EXTREMELY useful in helping me get the basic database-layout down,
but the feature of having automatic email's sent to doctor's when I add them
to the database would be so extremely useful for us that I cannot begin to
explain.

I wish I had more time in the day to learn this language - and I have tried -
but I just never am able find out how to execute this one task.

When you first replied, you were like a godsend to us because you were going
to - in the long run - save us an extraordinary amount of time, just by
taking a few minutes to tell me how to do this one thing.

However, clearly, my profound ignorance in this area has frustrated you and
tested your patience. That is why I am begging of you, if there is anyway you
can just tell me what it is you need to see (exactly) - to help us implement
this one feature - you would be making a huge difference across the board.

Im sorry for wasting so much of your time, I truly am.


majahops wrote:
>ASP.NET. Why, is this the wrong place for that?
>
>>> I didn't mean to be rude, im just desperate. Can I attach/send all of my asp
>>> and aspx files relating to this so you can see? Im sure you'll know which one
>[quoted text clipped - 10 lines]
>>
>>If you're not a developer what are you doing maintaining code!

--
Message posted via http://www.webmasterkb.com

McKirahan
Sat Oct 13 16:52:25 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:79a3686c391d5@uwe...
> ASP.NET. Why, is this the wrong place for that?

[snip]

Yes, this is a Classic ASP newsgroup.

The code I provided you before was for Classic ASP
not ASP.NET; you'll likely need something else.

Perhaps you should try this newsgroup:
microsoft.public.dotnet.framework.aspnet

Anthony
Sun Oct 14 03:03:45 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:798bc3f05f9b3@uwe...
> When I click "save" after adding a new record (which contains, among other
> fields, the person's email address), I want an email to automatically be
sent
> to that person (at the email that is in the field of that record). How can
I
> do this?
>
> Thanks so much, it really means so much to me!!!
>

One of the most difficult things to do is help a non-developer tweak ASP
code that has been auto-generated by some tool such as ASPRunner, Frontpage
or Dreamweaver.

We like to be able to get a clear picture of what is going on by reviewing
the code but auto-generated code is very, very difficult to follow.

Unfortunately I think that unless the tool you are using provides a means of
injecting your own code into the page any guess we come up with (and it will
be a guess) will fail or work for awhile and then when you tweak the page
the newly generated code will trash the changes made.

Have you got an email account through which to send these emails?

There is a line in your posted ASP (further down in the first branch of this
thread) that looks like:-

DoEvent "AfterAdd()"

My _guess_ is that its after this line you want to call a function to send
an email.
I recommend that you place the email function in a separate asp file.



--
Anthony Jones - MVP ASP/ASP.NET

majahops
Sun Oct 14 17:23:03 PDT 2007

Anthony,

Thank you. It turns out I am in fact using ASP, not ASP.NET. So, I call a
function, okay, awesome, but how do I set up my mail smtp server (which will
be gmail) and other info, and do I need to "call" that?

Anthony Jones wrote:
>> When I click "save" after adding a new record (which contains, among other
>> fields, the person's email address), I want an email to automatically be sent
>> to that person (at the email that is in the field of that record). How can I
>> do this?
>>
>> Thanks so much, it really means so much to me!!!
>
>One of the most difficult things to do is help a non-developer tweak ASP
>code that has been auto-generated by some tool such as ASPRunner, Frontpage
>or Dreamweaver.
>
>We like to be able to get a clear picture of what is going on by reviewing
>the code but auto-generated code is very, very difficult to follow.
>
>Unfortunately I think that unless the tool you are using provides a means of
>injecting your own code into the page any guess we come up with (and it will
>be a guess) will fail or work for awhile and then when you tweak the page
>the newly generated code will trash the changes made.
>
>Have you got an email account through which to send these emails?
>
>There is a line in your posted ASP (further down in the first branch of this
>thread) that looks like:-
>
>DoEvent "AfterAdd()"
>
>My _guess_ is that its after this line you want to call a function to send
>an email.
>I recommend that you place the email function in a separate asp file.
>

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

McKirahan
Sun Oct 14 19:20:13 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:79b3bc160c577@uwe...
> Anthony,
>
> Thank you. It turns out I am in fact using ASP, not ASP.NET. So, I call a
> function, okay, awesome, but how do I set up my mail smtp server (which
will
> be gmail) and other info, and do I need to "call" that?

[snip]

You don't need to set up an SMTP server if you are using GoDaddy for
hosting.

Save the script I posted as "Email.asp" and test it as-is.

majahops
Sun Oct 14 21:05:48 PDT 2007

*** I TRIED YOUR SCRIPT AS IS AND IT WORKED, IT SENT AN EMAIL TO ME, WHEN I
CHANGED THE TO: EMAIL FROM YOURS TO MINE!!! ***

Now all I need to know is how to make it send an email to the email address I
add for a doctor when I add them to the database and click "save".

The name of the email field is "email"... as you can see from the following
little shot of code in the doctors_add.asp page:

insert Email field
strValue=false
if avalues.exists("Email") then _
strValue = avalues.Item("Email")
if not errorhappened and not (vartype(strValue)=11 and strValue=False) then
if isnull(strValue) then strValue=""
ctype = GetRequestForm("type_Email")
rs("Email") = strValue

... So how do I use the value for "email" to send an email to when I click
on save, the relevant code for which is shown below - from an html file
called Doctors_add.html:

<TD style="BACKGROUND-COLOR: #e6e6fa" align=middle width=414 colSpan=2><INPUT
class=button id=submit1 type=submit value=Save name=submit1>
<INPUT class=button type=reset value=Reset> <input type=hidden name="a"
value="added"></TD></TR></FORM>

This is the part about the adding of the record in the original ASP:
'// after add event
DoEvent "AfterAdd()"
message="<div class=message><<< " & "Record was added" & " >>></div>"
end if
else
readavalues=true
end if
.. im guess I put the command for it to "call" email.asp based on a record
somewhere here, but have no idea how to?

majahops wrote:
>Awesome. How do I link it to the email address that I created in the record
>though? Thanks again!!!
>
>>> Anthony,
>>>
>[quoted text clipped - 8 lines]
>>
>>Save the script I posted as "Email.asp" and test it as-is.

--
Message posted via http://www.webmasterkb.com

majahops
Sun Oct 14 20:40:16 PDT 2007

Awesome. How do I link it to the email address that I created in the record
though? Thanks again!!!

McKirahan wrote:
>> Anthony,
>>
>> Thank you. It turns out I am in fact using ASP, not ASP.NET. So, I call a
>> function, okay, awesome, but how do I set up my mail smtp server (which will
>> be gmail) and other info, and do I need to "call" that?
>
>[snip]
>
>You don't need to set up an SMTP server if you are using GoDaddy for
>hosting.
>
>Save the script I posted as "Email.asp" and test it as-is.

--
Message posted via http://www.webmasterkb.com

McKirahan
Mon Oct 15 05:29:50 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:79b5adcd1e5fe@uwe...
> *** I TRIED YOUR SCRIPT AS IS AND IT WORKED, IT SENT AN EMAIL TO ME, WHEN
I
> CHANGED THE TO: EMAIL FROM YOURS TO MINE!!! ***
>
> Now all I need to know is how to make it send an email to the email
address I
> add for a doctor when I add them to the database and click "save".
>
> The name of the email field is "email"... as you can see from the
following
> little shot of code in the doctors_add.asp page:
>
> insert Email field
> strValue=false
> if avalues.exists("Email") then _
> strValue = avalues.Item("Email")
> if not errorhappened and not (vartype(strValue)=11 and strValue=False)
then
> if isnull(strValue) then strValue=""
> ctype = GetRequestForm("type_Email")
> rs("Email") = strValue
>
> ... So how do I use the value for "email" to send an email to when I click
> on save, the relevant code for which is shown below - from an html file
> called Doctors_add.html:
>
> <TD style="BACKGROUND-COLOR: #e6e6fa" align=middle width=414
colSpan=2><INPUT
> class=button id=submit1 type=submit value=Save name=submit1>
> <INPUT class=button type=reset value=Reset> <input type=hidden name="a"
> value="added"></TD></TR></FORM>
>
> This is the part about the adding of the record in the original ASP:
> '// after add event
> DoEvent "AfterAdd()"
> message="<div class=message><<< " & "Record was added" & " >>></div>"
> end if
> else
> readavalues=true
> end if
> .. im guess I put the command for it to "call" email.asp based on a record
> somewhere here, but have no idea how to?
>
> majahops wrote:
> >Awesome. How do I link it to the email address that I created in the
record
> >though? Thanks again!!!

[snip]

Within the ASP code (which is between <% and %>) what is the
name of the variable that stores the retrieved input value from the form?
Whatever it is just substitute it for the variable name "address" below.

<%
If Email(address,"your subject","your message")) Then
' success
Else
' failure
End If
%>

If it is "Email" the you should change the name of the function from
"Email()" to (perhaps) "Send_Email()" so the names won't conflict.

<%
If Send_Email(Email,"your subject","your message")) Then
' success
Else
' failure
End If
%>

Insert the above after you have successfully added a Doctor record.

You may also want to ensure that the email address is correctly
formatted before sending the email otherwise it will "bounce".

jp2code
Tue Oct 16 12:52:07 PDT 2007

Hey majahops,

Why didn't you say you were using GoDaddy? I've created 3 different email
forms on 3 different sites using GoDaddy.

The text will go before your <html> tag in your web page. Remember to name
it with the ".asp" extension - not a ".htm" or ".html" extension!

The code before the <html> tag will be read by the server, and will not
appear in the Client's browser when he views the source for your page.

I'll be happy to email you an example, if you'd like. Just shoot me an email
using my contact form on my crappy website:
http://www.joeswelding.biz/
It needs a re-design to make it less bandwidth intensive, but I am getting
lots of experience with Classic ASP on parts of it.

"majahops via WebmasterKB.com" wrote:
> McKirahan,
>
> Before I do this, where do I put all of this text? That has been one of
> the
> things that is unclear to me. Do I put it next to the like where the save-
> button is in the html, or what? Thanks so much again!
>

majahops
Tue Oct 16 20:44:57 PDT 2007

Joe, thanks so much! The only question I have really is how do I call the
specific email that I have in the persons record that I am clicking save for?


Thanks again.

jp2code wrote:
>Hey majahops,
>
>Why didn't you say you were using GoDaddy? I've created 3 different email
>forms on 3 different sites using GoDaddy.
>
>The text will go before your <html> tag in your web page. Remember to name
>it with the ".asp" extension - not a ".htm" or ".html" extension!
>
>The code before the <html> tag will be read by the server, and will not
>appear in the Client's browser when he views the source for your page.
>
>I'll be happy to email you an example, if you'd like. Just shoot me an email
>using my contact form on my crappy website:
>http://www.joeswelding.biz/
>It needs a re-design to make it less bandwidth intensive, but I am getting
>lots of experience with Classic ASP on parts of it.
>
>> McKirahan,
>>
>> Before I do this, where do I put all of this text? That has been one of
>> the
>> things that is unclear to me. Do I put it next to the like where the save-
>> button is in the html, or what? Thanks so much again!

--
Message posted via http://www.webmasterkb.com

majahops
Tue Oct 16 20:46:08 PDT 2007

Thanks a bunch McKirahan, I will try it right now. Just got back from a trip
to Sacramento. Sucks.



McKirahan wrote:
>> *** I TRIED YOUR SCRIPT AS IS AND IT WORKED, IT SENT AN EMAIL TO ME, WHEN I
>> CHANGED THE TO: EMAIL FROM YOURS TO MINE!!! ***
>[quoted text clipped - 36 lines]
>> >Awesome. How do I link it to the email address that I created in the record
>> >though? Thanks again!!!
>
>[snip]
>
>Within the ASP code (which is between <% and %>) what is the
>name of the variable that stores the retrieved input value from the form?
>Whatever it is just substitute it for the variable name "address" below.
>
><%
>If Email(address,"your subject","your message")) Then
>' success
>Else
>' failure
>End If
>%>
>
>If it is "Email" the you should change the name of the function from
>"Email()" to (perhaps) "Send_Email()" so the names won't conflict.
>
><%
>If Send_Email(Email,"your subject","your message")) Then
>' success
>Else
>' failure
>End If
>%>
>
>Insert the above after you have successfully added a Doctor record.
>
>You may also want to ensure that the email address is correctly
>formatted before sending the email otherwise it will "bounce".

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

majahops
Tue Oct 16 21:05:28 PDT 2007

So when I put in the code, I get the following message when I try to save the
record:

Error number 3749
Error description Fields update failed. For further information, examine the
Status property of individual field objects.

..

Here is my code (i renamed the function to "mail")

function mail
If mail(email,"your subject","your message")then
' success
Else
' failure
End If
end function

McKirahan wrote:
>> *** I TRIED YOUR SCRIPT AS IS AND IT WORKED, IT SENT AN EMAIL TO ME, WHEN I
>> CHANGED THE TO: EMAIL FROM YOURS TO MINE!!! ***
>[quoted text clipped - 36 lines]
>> >Awesome. How do I link it to the email address that I created in the record
>> >though? Thanks again!!!
>
>[snip]
>
>Within the ASP code (which is between <% and %>) what is the
>name of the variable that stores the retrieved input value from the form?
>Whatever it is just substitute it for the variable name "address" below.
>
><%
>If Email(address,"your subject","your message")) Then
>' success
>Else
>' failure
>End If
>%>
>
>If it is "Email" the you should change the name of the function from
>"Email()" to (perhaps) "Send_Email()" so the names won't conflict.
>
><%
>If Send_Email(Email,"your subject","your message")) Then
>' success
>Else
>' failure
>End If
>%>
>
>Insert the above after you have successfully added a Doctor record.
>
>You may also want to ensure that the email address is correctly
>formatted before sending the email otherwise it will "bounce".

--
Message posted via WebmasterKB.com
http://www.webmasterkb.com/Uwe/Forums.aspx/asp/200710/1

majahops
Tue Oct 16 21:06:19 PDT 2007

.. but i put a space between ) and "then" of course

majahops wrote:
>So when I put in the code, I get the following message when I try to save the
>record:
>
>Error number 3749
>Error description Fields update failed. For further information, examine the
>Status property of individual field objects.
>
>...
>
>Here is my code (i renamed the function to "mail")
>
>function mail
>If mail(email,"your subject","your message")then
>' success
>Else
>' failure
>End If
>end function
>
>>> *** I TRIED YOUR SCRIPT AS IS AND IT WORKED, IT SENT AN EMAIL TO ME, WHEN I
>>> CHANGED THE TO: EMAIL FROM YOURS TO MINE!!! ***
>[quoted text clipped - 31 lines]
>>You may also want to ensure that the email address is correctly
>>formatted before sending the email otherwise it will "bounce".

--
Message posted via http://www.webmasterkb.com

majahops
Tue Oct 16 21:37:10 PDT 2007

Any ideas?

majahops wrote:
>... but i put a space between ) and "then" of course
>
>>So when I put in the code, I get the following message when I try to save the
>>record:
>[quoted text clipped - 20 lines]
>>>You may also want to ensure that the email address is correctly
>>>formatted before sending the email otherwise it will "bounce".

--
Message posted via http://www.webmasterkb.com

McKirahan
Wed Oct 17 05:31:57 PDT 2007

"majahops via WebmasterKB.com" <u37541@uwe> wrote in message
news:79ced47655496@uwe...
> .. but i put a space between ) and "then" of course
>
> majahops wrote:
> >So when I put in the code, I get the following message when I try to save
the
> >record:
> >
> >Error number 3749
> >Error description Fields update failed. For further information, examine
the
> >Status property of individual field objects.
> >
> >...
> >
> >Here is my code (i renamed the function to "mail")
> >
> >function mail
> >If mail(email,"your subject","your message")then
> >' success
> >Else
> >' failure
> >End If
> >end function

[snip]

You're calling the function from within itself!

Why did you put the "If" statement inside of a function?

Look another look at what I gave you before.

McKirahan
Wed Oct 17 05:41:14 PDT 2007

"McKirahan" <News@McKirahan.com> wrote in message
news:ZOednS4At8ggnYvanZ2dnUVZ_sSlnZ2d@comcast.com...
> "majahops via WebmasterKB.com" <u37541@uwe> wrote in message
> news:79ced47655496@uwe...
> > .. but i put a space