Inputting dbase variables to ASPEmail code

[ChrisPols]

Hi,
I currently have a very wierd workaround to a simple problem. I have a page that selects a user from the dbase, works fine. Then I have an emailing code from ASPemail.com to send confirmation emails. But i'm using Post data for this. So I select stuff from a dbase, put it into "hidden" fields, and recall the page. This then inputs the data I need into the emailing function to send the emails.

Code looks like:
Mail.Body = Request("Title" )&". "& Request("Known_ As")&". "& Request("Surnam e")& ", has selected: "& Request("Member ship_Type")& ", using the Username: "& Request("Userna me")& ", has just registered on Global Handicaps Skukuza "

Now instead of "& Request("Known_ As")&" I would like to just have the dbase fields entered directly. So replace the code "& Request("Known_ As")&" with "<%=(MembersRS. Fields.Item("EM AIL_ADDRESS").V alue)%>"

What is the right way to do it as all i'm getting are errors. There must be some " or & i'm missing out.

Thanks
Chris

[iam_clint]

<%=(MembersRS.F ields.Item("EMA IL_ADDRESS").Va lue)%>looks fine to me whats the errors and post your code

[ChrisPols]

Hi,
Got the answer. The code should look like the following:

Mail.Body = Request("Title") &". " & MembersRS("EMAIL_ADDRESS") &". " & Request("Surname") & ", has selected: " & Request("Membership_Type") & ", using the Username: " & Request("Username") & ", has just registered on Global Handicaps Skukuza "

So instead of the POST input from Request I just put in the table MembersRS (note the EMAIL_ADRESS entry)

Great,
Thanks :)
Chris

[Anthony1312002]

Hey guys, I'm also trying to use ASPEmail to send an email when the form is submitted. The script tells me that the email was successsfully sent but I'm not seeing any emails. I enabled my SMTP server so that it allows me to transfer emails. I'm also running IIS on an XP machine locally. What could be the problem?

<%
' change to address of your own SMTP server
strHost = "MySite.GG. net"

If Request("Send") <> "" Then

Set Mail = Server.CreateOb ject("Persits.M ailSender")
' enter valid SMTP host
Mail.Host = strHost

Mail.From = Request("From") ' From address
Mail.FromName = Request("FromNa me") ' optional
Mail.AddAddress Request("To")

' message subject
Mail.Subject = Request("Subjec t")
' message body
Mail.Body = Request("Body")

strErr = ""
bSuccess = False
On Error Resume Next ' catch errors
Mail.Send ' send message
If Err <> 0 Then ' error occurred
strErr = Err.Description
else
bSuccess = True
End If
End If
%>