Loop Through A Recordset And Send Emails
I need to send an .ASP page as an email template using VBScript. I'd like to do so using CDONTS or CDOSYS. the script needs to loop through a recordset and send emails using data from SQL 2000.
when i try to send using a script i built the asp page pulls in without rendering the asp. how can i pull the rendered asp into my vb for emailing?
View Replies
ADVERTISEMENT
Anyone have any pointers as to how i could get asp to send some simple emails?
View Replies
View Related
is there a way of sending emails directly from iis without using an external
SMTP service?
View Replies
View Related
I've been working with ASP for 6+ years now, but in that time I've
never had any solid advice on how to build a secure system. So I
thought I'd ask here first.
Anyway, here's the situation: I have a client who wants to take credit
card information via ASP form (https) and then send the resulting
content (which may be either HTML- or text-formatted) to their email
account, which they access using Outlook (2000, I believe). I want to
build the system to make it as secure as is reasonably possible; at
the same time, they want to make it easy to read / retrieve their
signed/encrypted messages.
I know their are a lot of components out on the market that permit
programmatic encryption of data, but I don't know enough about what I
need to make an informed buying decision. I've heard that encrypting
the email content and then signing the entire message is the proper
thing to do, but how do I actually do that via code? And I definitely
don't understand how the message is handled once it reaches Outlook
(via POP, IMAP or Exchange -- they haven't decided on which yet).
My brain is full of things such as AES, MD5 + SHA-1, SSL, S/MIME and
such -- how do I put all these things together into an effective
solution?
View Replies
View Related
I know this question is stupid. But i need some advice for this. I
am trying to develop a website, which will allow the user send to order form
to the admin email. I am planning to use the CDONTS component method.
Can I just to localhost server to test, whether the form can be send
up to the admin's email. Or I must have the Hosting server to do that. Can
Anyone suggest me, how to I test my scripts can be successfully run (at
localhost), before I host it on the Web Servers.
View Replies
View Related
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
View Replies
View Related
I need no send birthday emails every day. I need something to check everyday on my database for birthdays, but I don't have any components to do that and I dont have rights to install it on my webserver.
Is there a way to do it without installing anything? Only through asp?
View Replies
View Related
I want to send automatic emails from my website after a definite interval of time.
I need a way to execute my ASP script repeatedly without any external triggering....
View Replies
View Related
I have two forms, one on each page. The user fills the first, then the second, then on the third page all the information is displayed for the user to make sure thats what they want to send.
Then they click submit on the third page and it goes through a database and depending on which category, state and county the user selected it will email all the information displayed on that third page to all the emails in the Email field in the database.
Now, I already have the first and second pages(easy enough) and the third page I can get it to display all the info how I want it and now I need to know how to go about emailing that info to the emails that match the specific fields? Right now all I have it doing on the third page, instead of submitting it for emailing, it just displays the info from the forms AND emails that match from the database. Code:
View Replies
View Related
I have an sql database, and an asp website. I need to send emails to users from the site. I have loaded the recordset with the email field from the table. I them send an email to all the emails in the recordset. I use the BCC field to do this. The problem is, sometimes the emails get missed judged as spam or junk. How can I fill the TO field of the email instead, with the emails from the recordset, and send an email to each address individually, in like a loop or something? So like, it will go through and send an email to email1, then loop back through and send one to email2, and so on....
View Replies
View Related
Is it possible to loop through recordsets using javascript? If possible, can show me an example.
View Replies
View Related
Given a page with 12 thumbnails numbered one through 12 I am trying to figure out how I can let a user click on any of the twelve thumbnails and be taken to page that has a forward and backward arrow so they can go through the other images in order.
So if someone clicks on the 7th image the next page shows that image enlarged with a foward arrow taking them to image 8 or a reverse arrow taking them to image 6. When the controls get to image 1 (or image 12) the navigation adjusts to just keep going through the images.
View Replies
View Related
I have a recordset and an array which i get from a form submission. I want to loop through all recordsets and compare one by one with the values I get from the array. Is it possible to give me the general construction because I am stuck?
View Replies
View Related
I currently use Do while loop, but I'd rather use a For Loop though I have never gotten the hang of them. Would some one please be so kind as to show me how to loop through a
recordset.
View Replies
View Related
Is it common practice to create a recordset object inside of a loop? Does it create multiple connections to the database?
View Replies
View Related
I've got this code that loops through a recordset and prints the whole thing out in an html table. Sometimes it takes 30 seconds to a minute to display a little over 2000 records (like 25 columns). My boss feels that it needs to be faster even though another internal reporting system that works similarly takes far longer than mine.
I've ruled out the database execution. I have code that prints out after it finishes going to the database. It shows up almost immediately.
I set up a javascript timer that says the entire execution, including the database, is taking around 1.5 seconds every time.e.
View Replies
View Related
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
View Replies
View Related
I'm trying to pass a parameter from a for loop to the nested while loop
but only the first counter is passed. Here is the code:
View Replies
View Related
I have a recordset that I loop through all of the data within a table, within the same loop, I am trying to add another loops that pulls information from the first recordset to base the second recordset off of: Code:
View Replies
View Related
i am trying harder to mix this 2 solutions... but without success... the below on seen to be grabing a template and replace the data with the values posted in a form Code:
View Replies
View Related
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
View Replies
View Related
Anyone want to give me any pointers as to how to send emails from asp?
View Replies
View Related
What is the best option?Im writing a forum so i need a universal solution...
This means i cant use something like ASPEmail as not all ASP servers have this.
So what do i use? Someone suggested to me CDONTS but then said you have to set up the server or something.Do all web servers have this pre configured.
View Replies
View Related
Is there any way we can send off an email from a web hosting server that does not support CDONTS and cannot register any components to their server. They have no SMTP server as well.
IS there any web site that supports any one of these for FREE or better yet is there any other way to send off an email without CDONTS and components? Is it possible to like redirect to another mail with just scripting?
Appreciate any response to this matter.
View Replies
View Related
I have a stored procedure which sends out an email to all the users
listed in the database. for some reasons I am not getting all emails.
could someone offere some assistance? Code:
View Replies
View Related
I am using ASP to send order confirmation emails to customers. However i want the emails to appear as HTML in the emails.
I have Successfully done this but i need to know how to attach CSS to the emails, so that it can look exactly like the html page i design.
I am using the CDONTS.Newmail component with the .body attribute.
View Replies
View Related
I am working on a piece of software that needs to store email data in a SQL server table. Been flicking around and it looks like the ASP mail components are a good way to go. Basically I will be recieving mails from a pop3 server (prob outlook) and using the same program to put the data in a database.
View Replies
View Related
I don't necessarily need code here, just some guidance to my thought process.
I have built a system for a hospital where users can sign up for classes that the hospital offers. Now, I want to be able to send the users a reminder email a day or so before the event/class. In the database, I have all the user's info in one table. Another table holds the registrations with keys to the user table and the key to the table that has a listing of the classes.
How do I now go about automatically looking through the class table to find out if there is a class in the next 24 hours, and then send an email to all the people registered for that class?
View Replies
View Related
Has anyone had or heard of IIS not passing emails or SSL connections, thereby disconnecting or making the server useless?
I had a virus that seems to have done this.
View Replies
View Related
I need some advice on how to write an email script in asp. I am farely new to asp but so far i have manage to understand most of the materials i've covered for this language except for sending emails from a form.
I've read the following tutorial ->URL twice, but i can't get the script working.
What am i doing wrong?
I am working on my personal box at home, do i need to have a mail server running? do i need to have addtional asp component install?
View Replies
View Related
I have emails being created and sent using CDO and it is working well but, the email is being sent twice. I only call the .send once (per person) but it comes through twice.
Code:
View Replies
View Related
anyone know a good way of tracking an email so that i know if theyve been
opened? and preferably somethign where i can identify the recipient
(matching with our crm)?
View Replies
View Related
I have an exchange server, that I sometimes use to perform mail shots to
clients on our database, these can be upwards of 1000 at a time.
As we don't want different clients to see who we are working with we put
these mailshots in the bcc field of the mails.
This can sometimes cause a problem as we are getting alot of mails bounced
back. I would like to write a script to have these emails sent
out individually using the to: field of the mail. I have googled for
examples of doing this but haven't found anything useful yet
View Replies
View Related