Email Emails In The Database
Does anyone no or have a link to how i can send a Newsletter/Email to every Email address in my Database?
View RepliesDoes anyone no or have a link to how i can send a Newsletter/Email to every Email address in my Database?
View RepliesBasically one of our clients has asked us to save all emails sent to a particular email address. eg.'bruce@almighty.com' to a database.
I don't even have the slightest idea as to how this could be done via ASP on a web server.
I would like to send the same email to every email address that I have in a table.Only complication is that some records have an email address and some don't (some people dont have email addresses.
I had a go and made an array and used the len(email)>0 idea, so that if no email address, skip sending and email. Guess just after some standard code, nothing fancy. The site is on a commercial server running win 2000 .
I want to use a simple CDONT mail script to allow the administrator of a site to send an email blast to their users. there are approx 1600 emails in the MS SQL db table. I would like to parse the entire email address column and get a variable that is all the email addresses separated by a comma so that the form picks it up as all the emails in the 'bcc' field as in the eg. below..I know there has to be an easier way but I want to get these guys up and running.
<%
objCDO.To = "Recipient@oursite.org"
objCDO.From = "mailer@oursite.org"
objCDO.bcc = "$variable_of_all_email_addresses"
Dim txtSubject
txtSubject = "Insert comments and case info here"
objCDO.Subject = ""***ATTENTION*** NEW CASE - MISSING CHILD"
objCDO.Body = txtSubject
objCDO.Send
%>
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:
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.
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
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 RelatedI 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.
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 RelatedCan ONE form with ONE submit button send the results to a database and also send the results via email?
View Replies View Relatedive 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?
I trying to send an email using CDO Mail compontent with ASP.I would like to pull the email address from a database. I have created recordset, and I can get the first address to work, but I can not figure out a way to make it loop so it pulls all the email address from the database and sents the email to all of them.
View Replies View RelatedI have another script where i pull all the information from the database and I want to send it to the person. What they do is they enter in their email, and if the email matches, than it will email them their login information.
How do you grab the info and than use that info and put it into an email to send?
Here is my code thus far for it: ....
How to do i send database information to an html email using ASP?
View Replies View Relatedi've got a database in ms access. using ASP (vbscript) and IIS. I can send text e-mails through ASP but i want to attach a file from the database to the e-mail when it is sent. can anyone give me any hints on how to get the data from access, attach it to the e-mail and send it on?
View Replies View RelatedI have the following code which displays email address from a database
However, I need to have the email address highlighted so that on clicking
the email box would open up with the email name filled in. Code:
I have been asked to try and write a program that basically pulls some info from a sql database and automatically emails it to an email address on a certain day of the week .
So if anyone can offer advice or if they know of any script or tutorials online.
i made this asp script that should email and insert the data into a database but somehow i don't think I've done it right. Code:
View Replies View RelatedI’m attempting to insert some basic information (name, address, details) to the sql database and send a notification email (at the same time).
Right now, I can insert the information to the DB after I click submit, but how can I also receive an email? Please give some ideas how to do it.
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....
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
View Replies View RelatedOK - I have a shopping basket with data in a database. Once the person
has successfully completed their order I want to be able to send them
an email with the products ordered roughly in the following format:
Product Price Quantity
prod1 £6.99 1
prod2 £5.99 2
Postage £0.50
Total whatever..I'm
lazy
Formatting would be a little different (just spacing out the prod
table a little more.
Any ideas or links to scripts that do this?. I've been looking for a
while now but have had no luck in finding a solution. I just want to
send a text email (and not html).
The other thing is that on the last page but one, this shopping basket
is displayed. Is there anyway I could capture the html data from that
page, store it in a session variable and then generate the email after
the order has been completed (so sort of like sending a mirror of that
page)? In that case having a HTML formatted email would be ok.
Anyone want to give me any pointers as to how to send emails from asp?
View Replies View RelatedWhat 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.
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.
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:
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.
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 RelatedI 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?
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.
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?
Anyone have any pointers as to how i could get asp to send some simple emails?
View Replies View Related