Blank Email Entry In Database (SMTP Badmail)
When a file is uploaded, notifications go out to Admins. Currently Admins have the ability to have 3 email addresses that the notification can be sent to.
Now lets say they only have 1 email address for a contact. When I run the code below, it cycles through to everyone that needs to be contacted and sends email to all 3 addresses.....BUT #2 & #3 are empty and then in my SMTP folder I receive a bunch of files in the badmail folder.
I need to correct this so that I can eliminate having to go and purge on a daily basis.
Now I am sure that there is a better way of doing this... I inherited this and am looking for some help with correcting this....
View Replies
ADVERTISEMENT
How do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then
Response.write(bla bla)
else if tf.value = null then
Response.write(bla bla)
else
Response.write(bla bla)
end if
*Note, where the word null is, I have also used the string "" and it still does not work.
View Replies
View Related
can we send email from our internal server without using an external SMTP provider?
View Replies
View Related
I was able to send email via the server in both .NET and ASP (using CDO for ASP). However I had to configure a SMTP server for this to work, which means the email will be sent via the server's SMTP service. so this could mean a lot of overload on the server. So as to reduce the work on the server, is there another way to send email to people?
View Replies
View Related
I am having problems trying to send emails using IIS 5.1 and ASP on a XP Pro box
I think that it is a configuration problem in my SMTP setup
I can send emails using Telnet but when I send via ASP they all end up in the Queue folder
ASP is not generating any error messages
Have tried code using CDO and CDONTS but I do not think it is a code issue
Sometimes I get a system event error saying that cannot do a DNS lookup on my send address
Any suggestions please
Properties for SMTP on my system:
General IP address : all unassigned
Access Relay: {my computer IP address}
Delivery Advanced Smart Host: mail.bigpond.com
Delivery Advanced Fully qualified domain name: {my computer name}
View Replies
View Related
I'm using CDO object to send email but it doesn't send any email and it does
not give an error.
My code look like this: .....
View Replies
View Related
i've been looking EVERYWHERE and I can't find anything on how to send an email within asp. But not just an email, my smtp server requires authentication and i haven't been able to come across anything that supports sending username/passwords.
View Replies
View Related
I've been using CDOSYS Mail and this bit of code fine for a year. Well, we wanted to change the method of sending email from the Webserver sending it, to designating a specific SMPT server.
So, I found this code on MSFT's web site (MSFT CDOSYS SMTP ) that will allow me to do this, and it works, except that the redirect command that I have at the end of the file no longer works. I have no idea why.
Thi is the error I get:
error '8004020f'
/asp/send_email_foundation_conf.asp, line 78
Code: ...........
View Replies
View Related
Is it possible to set up server-side mail services such that when someone
e-mails to a certain address, the contents attached to that mail are
processed and the processed content is returned to the user, again, as an
attachment?I installed a server-side component for managing graphics. "Wouldn't it be
nice," thought I, "if untutored staff could email graphics to a certain
e-mail address to have them resized and returned to them.")
I understand how to handle the graphics processing and the sending. I don't
understand how to set things up so that e-mailing to a certain address will
trigger the start of an application. Ideally you could do this all within
ASP. Is this possible?
View Replies
View Related
Does anyone know how I can use asp to access a specific entry in a microsoft access database table without having to run a search of the entire database? I figure this can be done with the primary key, but I'm not sure how to do it. I've looked for tutorials, but none seem to deal with this.
View Replies
View Related
I am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it
Sub Delete()
SET Conn = SERVER.CREATEOBJECT("ADODB.Connection")
Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb")
sqlWhere = ""
aSelected = request.form("Select")
sqlWhere = "ProspectId IN ('" & aSelected & "')"
sql = "Delete * from tblProspect where " & sqlWhere
Conn.Execute sql
Conn.Close
Set Conn = Nothing
RESPONSE.REDIRECT("prospects.asp")
End Sub
View Replies
View Related
I have a string of ASP code that writes a new database entry into my SQL server table. Is there a function that I can run directly after the database entry code, that can tell me if the data was successfully entered? Eg of current code:
SQLCode = "INSERT INTO GarProductList VALUES (" & "'" & App_Name & "'" & ", " & "'" & Option_Number & "'" & ")"
response.write "SQL Code is: " & SQLCode & "<br>"
Set objRS = MyConn.Execute (SQLCode)
<< perhaps call certain function here to verify SQL table was updated? >>
If database update successful -> function should return 1 If database update fails -> function should return 0 ... or something like that. In any case, some exception response should be returned.
View Replies
View Related
It seem that I did not configure the SMTP service on a Windows 2000 server correctly because all the email is been sent to InetpubmailrootQueue directory. Do I need to install Outlook for the email to send the mail to the recipient?
View Replies
View Related
My question is do ASP need to declare smtp server when send email using CDonts function?
View Replies
View Related
I am running Win XP and have installed the IIS SMTP service, however I'm not sure what I need to do to configure both the SMTP service and CDOSYS properly to allow me to send out email from an ASP script.
THE PROBLEM:
What is happening is the email is not sent and goes to the 'c:InetpubmailrootQueue' folder. I have checked the event viewer and the error I receive is:
Message delivery to the remote domain 'yahoo.com' failed for the following reason: The remote server did not respond to a connection attempt.
I believe the SMTP service isn't setup correctly or I haven't configured CDOSYS properly in my ASP script.
The CDOSYS part of my ASP script is setup as follows (I am using Javascript with ASP btw):
Code: .....
View Replies
View Related
I have Road Runner cable internet access and Im working in a local development environment (writing .ASP) and have a site running on my network on a windows xp pro machine via IIS with CDONTS installed.
When I try to send a confirmation email (simple text) via CDONTS the message is built but remains on the server in the QUEUE folder ... how can I tweak the SMTP settings on the server to allow me to send email out from the server...
just the occassional test as I develop sites - not looking to spam and have a fairly full featured router to block external access to SMTP machine so its not abused.
View Replies
View Related
I have a CDONTS script which has been sending mail from a client's website form to their address. However, the script has suddenly stopped working after three years of working fine. It doesn't error, they just don't receive the mail any more. I've tried CCing myself in the script and can confirm the mail is not getting through. The script itself is tried and tested and syntaxially correct, and it is hosted on a windows 2000 server which has not been changed or reconfigured at all recently.
I think the problem is because they're using their own exchange server, not the web hosts' mail server. Therefore I would expect that mail sent from the web script wouldn't go through because there is no local mail server to process it.
The problem is that the script hasn't changed, the host say their system hasn't changed, and the client's IT team say their exchange settings haven't changed!?!
I could set up a CDOSYS script to use their Exchange server to deal with the email, but their IT support won't allow relaying, so I don't think this is possible.
Is connecting to their Exchange box the only option, or should the website host still be able to process the web-script-generated mail despite not being their mail provider? I'm getting a lot of grief here, but it can't be the script that has suddenly broken because nobody has touched it!
View Replies
View Related
I created a feedback form for my website that has only 2 required fields. When you submit the form it calls my asp page which puts the information in a database and then sends me n email with the information that was entered into the form. The problem is that the form only has two required fileds, and if the remaining non required fields are left empty when the asp page is called it does write to the data base, but does not send me any email. However if I go back in and put somethng in every field in the form then when I submit the form and my asp page is called it writes to the data base and sends me an email with the all the information I entered in the feedback form. Is there a way to tell my asp page that it is ok to send the email even if the non required fields are left empty? I really do not want to have to go back through the form and put default values in for each area of the form? Also is there a way to have an error displayed if the email is not sent? My asp code is below....
View Replies
View Related
what i am trying to do is when the database field is empty to not display the box (table) that is in my css file, whereas when there's something in the field i would like the box to display!!! So i'm basically trying to get a 'when field empy, do nothing!!! my code at present generates the box no matter whether the field is full or not!!! Code:
View Replies
View Related
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
View Replies
View Related
When rs("firstname") is called on my page,
it returns the first name and a blank space before it.
I want to pass it throught the QueryString,
but URL's can't have blank spaces.
On my DB (Access), the none of the firstnames have any spaces in front of them.
Any ideas?
View Replies
View Related
My code has no error and I'm not sure whether it send my mail or not. Firstly, it was in the Queue folder, and then they all went to Badmail folder, is it because of the firewall? I'm using Unis's VPN, does firewall block all the mails so they all coudn't be sent? Here's my code:...
View Replies
View Related
Usually when I setup a web form with CDO I either set the "From" field
in the email to either:
1. The email address of the person filling out the form, in which case
user errors often result in the mail getting stuck in the badmail folder
and not being sent
2. An alias for the client (like Join Bytes!) to guarantee that it
gets delivered, but this is less convenient for the client as they can't
just reply-to the message, they have to manually change the address (not
a big deal, but annoying)
Is there another way to guarantee that even with a bad "from" address
scenario #1 will work every time? Or some other option I'm too dense to
have realized?
View Replies
View Related
I am working on a listing for sending emails via CDONTS component...
I have installed SMTP service on my machine and tried running the sample code....No errors appear, yet no mail is sent in the long run...All necessary services are up and running (IIS Admin, WWW and SMTP).
Another thing is that i have checked to see if Default SMTP Virtual Server is listed under the Internet Services Manager pane tree, but nothing seems to be there except Default FTP Site and Default Web Site....
The question might seem silly but...do i have to have a Mail Server installed.....?
How can i determine the cause that prevents the mail from being sent...Logs don't help much....Is there a way to detect the actual presence of the component...?
View Replies
View Related
Im 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.
View Replies
View Related
Our network administrator does not want to install the IIS SMTP server on
our intranet. He wants me to use our existing SMTP server
"mail.smpi.siemens.ca". Can I do this with IIS?? Is this a setting in an
ASP if I'm not running the IIS SMTP server?
We are running on Windows 2000 SP4 with IIS5.
View Replies
View Related
I wrote some lines of code on ASP but I am not sure about the logic...Because when I try to run the program it gives me error... I don’t know what is the wrong with the code… please help me... I am trying to read certain information from Access database for certain student and send the information to his email...
Example:
The student will enter his ID and click send then a message should be send to his email with his locker informatio
View Replies
View Related
I have an ASP page that inputs data into an Access database via form on page. The submit button on the page stores the data into the database without a problem. What I need to happen when the submit button is pressed is data stored into the database and an email sent to the administrator. Is this possible for me to do.
View Replies
View Related
I am creating a Change Management System where users log in and Log a request for a change to a problem that they are experiencing. The information is filled out in a HTML form and using ASP the information is sent to a MySQL database. This part is working fine. What I would like doing is if its possible, although I have seen it on other sites is when the user submits the form for the information to be sent to the database, i would also like an email generated with some of the information on it.
I am using a windows 2003 server and have used CDO in the past but don't realy know a lot about it. To be honest I don't realy know where to start with this problem, how to get the submit button to store the information and also generate an email. Any help would be greatly appreciated. I can send my code if it would be of help to anybody.
View Replies
View Related
I currently developing a Email marketing application using asp and aspemail for a client. They requested the application to be able to mass email to their client that is store in an access database. So how can i initiate the application email to all the email store in the database?
View Replies
View Related
Can ONE form with ONE submit button send the results to a database and also send the results via email?
View Replies
View Related
Does anyone no or have a link to how i can send a Newsletter/Email to every Email address in my Database?
View Replies
View Related
ive noticed loads of online apps that allow emails sent to a particular
address, to update a database i.e. ta-da.com - can this be achieved with
COMless scripting in asp?
View Replies
View Related
