Is it possible to send an email based on a query to an Access db? My intention is to send out an email based on say a drop down item the user selects. Does anyone know if I can use a SELECT statement to pull the record and format it into an email?
View RepliesIm running a simple mail system program which emails newsletters to a database list of 3000+ users.
The program loops through a database containing the emails and sends them out using ASPEmail.
My question is, is there some way i can validate each email address so that if there are invalid characters e.g. the space in "blah @blah.com"
it will skip the record and continue the loop.
At the moment i have a working program however, whenever the program comes across an invalid email address it stops at that record and prevents the program from emailing any further.
I have a database that has an email column that either contains an email address someemailaddy@mail.com or a value "n/a" All I want to do is loop through the column in ASP by checking to see if the "@" is in the address and if it is feed the email address into a mailto: href tag . I think something is wrong with my code because it just returns the name but not the href.
<% IF InStr(1, contactObjRS("Email"), "@") = 1Then %>
<a href="<A href='mailto%=contactObjRS("Email'>mailto%=contactObjRS("Email") %>"><%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %></a></font>
<% Else %>
<%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %>
<% End If %>ted.
Ok.. I have a form the user fills out. An email is sent to them and one to our office with a link to the DB so they can view all the info. My form works fine, my emails work fine. The info gets inserted in to the DB fine.
What I would like to do is:
When the link is sent to our office, I would like it so when they click the link it opens the DB right to the info from the link. You know, like when you get an email from here saying someone posted your link has it set so when you click it, it will go right to that post.
So there you have it, any takers.. I sure could use this, otherwise they open the DB and have to search for the info and they do not like having to do much work..
I am having a problem formatting an email message which comes from a form.
I am currently having difficulty with the <br> tag which I am using for line spaces within my email. I am getting an expected statement error message which is pointing to the line which is underlined below. I can't think what is causing this.
The code for my processing page is below:-
1. I want users to type in their email address on a textfield, and after users press the "Submit" button. The info will automatically go to another person's email to receive a compliment, suggestion, etcetera.
2. Another is how to include the message written on a textarea of a form with the ASP code supplied below: Code:
how to write to check verification valid email thru nslookup or mx record or dns record. Is it possible to do that. Is there any tutorial from sitepoint, previously found it but i lost the link.
example to check assume test@domain.com is not a real email, abc@domain.com is real email
how do u check it.
i used the following script but it won't send the email. any suggestions why?
<%
Dim TBdy
Dim MyCDO
CR = Chr(13)
Set MyCDO = Server.CreateObject("CDONTS.NewMail")
MyCDO.From = "person@something.org"
MyCDO.To = "allstar@aol.com"
MyCDO.Subject = "collegebound info"
TBdy = Request.Form("cb_name")
MyCDO.Body = TBdy
MyCDO.Importance = 1 (Normal)
MyCDO.Send
Set MyCDO = nothing
%>
Just starting to play with scripts, and need a little guidance. I want to check to make sure that the email addresses users enter in a form are identical before it will allow them to submit. here's what i have:
the variable for the second email address is EmailFrom2
'validation
Dim validationOK
validationOK=true
If (Trim(EmailFrom)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("emailerror.htm?" & EmailFrom)
If (Trim(Name)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("nameerror.htm?")
If (Trim(CityState)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("citystateerror.htm?")
If (Trim(SchoolName)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("schoolnameerror.htm?")
here is the script i use:
Set myMail=server.CreateObject("CDO.Message")
myMail.Subject="subject"
myMail.From="me"
myMail.To=request.form("email")
myMail.TextBody="hello"
myMail.Send
set myMail=nothing
this script sends emails to some addresses but not others--and its based on the email service it's sending to. for instance, hotmail email addresses get the email, but mail.com email addresses dont get the email. i have tried sending it to other email hosts, too, and still, some work, some don't. what is going on here?
I am using CDONTS component to send email in ASP.
The code is some thing like this:
Dim Mail
Set Mail = Server.CreateObject("CDONTS.Newmail")
mail.From = "abc@hotmail.com"
mail.to = "xyz@hotmail.com"
mail.subject = "Test Email Subject"
mail.body = "This is Email body message"
mail.send
Now the question is that this code will use the Default Virtual SMTP Server in IIS, but I want to use my ISP's SMTP server. please tell me how to do this. I have used my ISP's email server in Outlook express and it is working fine. Please do not suggest to use "CDO" or "CDOSYS" to use for sending emails because I must have to use "CDONTS".
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedI want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
has anyone got a function or subroutine which will remove blank out or remove email addresses.
i've wrote a function which will remove valid email addresses, it's pseudo addresses such as "blah @ blah.com" or "blah_at_blah_dot_com" or "blah_at_blah_._com"
the function is basically to stop users posting an email address in a message.
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
View Replies View RelatedI've created an com+ application for sending emails with multiple attachments.The component looks like this:
Public Function SendMail3(toAddr, whoAddr, docSubj, docMsg, ByVal docType As Integer, Optional cc = "", Optional bcc = "", Optional sFolder = "", Optional user = "")
On Error GoTo MailErr
Set oFlds = oConf.Fields
oFlds(cdoSendUsingMethod) = cdoSendUsingPort
oFlds(cdoSMTPServer) = SMTPSrvr
oFlds(cdoSMTPServerPort) = SMTPPrt
oFlds(cdoSMTPAuthenticate) = cdoBasic
oFlds.Update
Set oMail = New CDO.Message
oMail.From = whoAddr
oMail.To = toAddr
If (cc <> "") Then
oMail.cc = cc
If (bcc <> "") Then
oMail.bcc = bcc
If oFSO.FolderExists(sFolder) Then
Set oFolder = oFSO.GetFolder(sFolder)
For Each oFile In oFolder.Files
If InStr(oFile.Name, "_" & user) > 0 Then
oMail.AddAttachment oFile.Path
FileSize = Format((FileLen(oFile) / 1024) / 1024)
SumSize = SumSize + FileSize
oFSO.DeleteFile (oFile)
End If
Next
End If
End If
End If
If ((docType Mod 2) = 0) Then
oMail.TextBody = docMsg
Else:
oMail.HTMLBody = docMsg
End If
If (SumSize > 10) Then
ErrorStrMail = "Attachment size too large!"
GoTo MailFlee
End If
oMail.Subject = docSubj
Set oMail.Configuration = oConf
oMail.Send
MailFlee:
Exit Function
MailErr:
ErrorStrMail = Err.Number & ":" & Err.Description
Resume MailFlee
End Function
When I call this component from an asp page,I don't get any error,but the mail doesn't work.....did I do something wrong?
I have set up an interactive database with a .asp page requesting information to include an email address. After receiving a response and viewing the database no email address is entered. How do I set up my table to except an email address?
View Replies View Relatedcan you use free email accounts (hotmail. yahoo) too send emails with CDO?
View Replies View RelatedIs there anyway to send email with ASP without downloading a bunch of stuff? I am new to ASP and I am using IIS on my computer and I can find anyway to send emails from my site.
View Replies View RelatedI need to be able to email to all email addresses in db (like a newsletter) I have seen some code samples but really need something simple and web based.
View Replies View RelatedI am sending email using CDO..the code I am using sends an ASP page,
the HTMLpart is recognised,but<%code %> is not(basically I am passing some query strings to ASP page),
SUB SENDEMAIL(refno1)
Dim myMail
dim mailmessage
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Sending email with CDO"
myMail.From="mymail@mydomain.com"
myMail.To="ravi@v.com"
myMail.CreateMHTMLBody "http://localhost/mailer/thank_you.asp"
myMail.Send
'mymail.AttachFile
'mymail.Send
end sub
Does anyone knows about any sample code that I may be able to use to send email when an user click the submit button?
View Replies View RelatedI'm a php guy being forced to work with asp. I have a csv file that is going to have 100 names e-mail addresses. I need to create a script that will read thru the file and then send out one e-mail per name. I've had success adapting brainjar's scriipt for my needs in the past but am not sure on how to read a csv file to get the names and addresses.
I'm looking for some advice on reading a csv file to load the values into an array and then how to handle looping thru it 100 times.
I need help sending an email.
This is what I'm using to process it:
<%
my_from=request("mail-fromName")
my_fromAddress=request("mail-fromaddress")
my_to=request("mail-toName")
my_toAddress=request("mail-toaddress")
my_subject=request("mail-subject")
my_relay=request("mail-relay")
I want to be able to redirect and I don't know if this is the best way to do it or not. I also want to include it in my project but when I try to place it inside my project it gives me an error that there can only be one declarative. Please help as I am new to ASP
I'm using the following codes to send the HTML form as an email. While submitting the form i'm not getting any error message. But i'm not getting the email also.
<%
Dim Mail
Set Mail=Server.CreateObject("CDONTS.NewMail")
Mail.To="me@mydomain.com"
Mail.From=Request.Form("FirstName,Email")
Mail.Subject="Listener response"
Mail.Body = "Language ="+ Request.Form("cboPrimary") + chr(13) + "Program Name ="+request.Form("cboSecondary")+ _
"Listener's Name=" + request.form("FirstName") + request.form("LastName") + chr(13) + _
"Address="+request.form("Address")+chr(13) + "Phone Number="+request.form("DirectPhone") + chr(13) + "City=" + _
request.form("CityStateZip") + chr(13) + "Email ID=" + request.form("Email") + chr(13) + "Comments=" + request.form("Comments")
i have a requirement of sending an email thru ASP, I am using Interdev to
develop the asp
page to send the mail, i am using windows XP & IIS 5.0 version.
i am using CDONTS, i downloaded the dll and have registered it in registry,
my problem is, code seems to be working and email is not being sent, i have
tried out serveral things which
were listed in websites but nothing i got right. all the mails are being
stored in queue folder in
Inetpub/mailroot folder. i doubt whether the norton antivirus which i have
installed is blocking or any settings i have missed out in SMTP properties
or in IIS settings.
How come my image is not included sent through email Code:
.
.
.
mbody=mbody&"<br><br><table width='200' border='1'>"
mbody=mbody&"<tr>"
mbody=mbody&"<th scope='col' bgcolor='#009900'><img class='logo' src='images/logo.gif' alt=''/></th>"
mbody=mbody&"</table>"
Mail.Body = mbody
Mail.Send
Set Mail = Nothing