How To Mass Email From Database

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


ADVERTISEMENT

CDO Mass Email

I have a test and production environment. The code works fine on test
but behaves erractically in production. The script needs to email people
who are subscribed to a particular service. On test it is a small list
but the list on production is fairly large. Does the CDO object have a
maximum number of people that can be BCCed? I also have email addresses
with hyphens in them, are there special characters, (other than @), that
have to be respected? I have seen some other posting with people having
issues with the CDO object and one of the suggestions is to:

# Try using a SendUsing value of 1 (pickup) instead of 2 (port). E.g.
the following line:

cdoConfig.Fields.Item(sch & "sendusing") = 2

Becomes

cdoConfig.Fields.Item(sch & "sendusing") = 1

What is the difference between these two? The webserver is juts using
the default SMTP server, is it going to work with a setting of
cdoConfig.Fields.Item(sch & "sendusing") = 1? Where are they picking it
up from?

View Replies View Related

Is ASPMail Good For Mass Email?

I am trying to send out a mass email newsletter. I have 600+ subscribers in our SQL Server Database. Well, is ASPMail (Server Object's product) good for this? If so I have some concerns about the error handling and assuring people don't continue to recieve the same email. Does anyone have expierence with this? If so, what is your advice?

View Replies View Related

Mass Email Body Repeated Several Times.

I am testing a mass emailer that I will be sending out this week. I use ASP to read email addresses from a db table which is contains a list of email addresses of those who will receive the email blast. I have included myself to see the results of the test. I noticed when I received the email, the body or content of the email was repeated as many times as there are people in the email list the code was reading from.
Can someone tell me what I did wrong in the code below?

Code: ....

View Replies View Related

Mass Email Using CDONTS...how To Get The Emails Into A Delimited Variable

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

%>

View Replies View Related

Email Validation Of Email Address Within An Access Database

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

'Mass-mailing' With ASP?

I just took over maintaining an ASP codebase for sending out
newsletters by mail, as well as basic subscriber maintenance.

Thing is working ok today, with ~200 subscribers, but there are plans
on selling this 'solution' to clients with substantially higher
demands; at least in the low 1000's..

Would you consider asp suitable for this purpose? Would be a
definitive plus not having to use other technology, but i'm concerned
about timeouts and whatnot while sending out such a batch of mail.

Guess it could be made workable with tons and tons of logging, and
maybe generating a client redirect every X mails, to restart/keep the
script going?

Or is it perhaps possible to fork off a new thread and do this as a
real background task? I'm not too knowledgeable on ASP, and neither
was the guy who wrote this system in the first place, unfortunately.

View Replies View Related

MASS Insert Using ASP/SQL

I have a table in SQL server, that has three columns:

ID, Asset, Keywords.

i.e.
ID Asset Keywords
1 Car Mercedes
2 Car Toyota
3 Color Blue

Ok, what I'm trying to do through my asp page (since I cannot do it through SQL, seeing as how it appears that what I want to achieve would be outside the scope of why it was created)... is I'm trying to run a query that will get a list of the assets available and then string the keywords for that asset to a variable. Code:

View Replies View Related

Use Mass E-mailer

I tried using the one listed here http://www.aspfree.com/c/a/ASPCode/...rom-a-database/ but I keep getting an error which I've posted but haven't found an answer for yet. Does anyone know of any other one that I can use. I basically want to be able to pull a list of the emails out of my db and send an email to those addresses.

View Replies View Related

Mass Emailing

I'm given a DB with everyone's particulars including emails which
I'm supposed to retrieve all their emails and do a mass reminder email.

Can someone give me some ideas as how am I supposed to go about doing it
using asp and vb as I'm quite new with the languages.

View Replies View Related

CDONTS Mass E-mail

My problem is, when I send e-mail to our members, not all of them are getting them and there is no rhyme or reason. I was thinking of re-writting the program to go through MS Outlook so our Exchange Server will take care of sending it. Then again, probably there is someone who can help me figure out why some e-mail are not getting delivered even though they have valid e-mail addresses. There must just be about 25-35 out of probably close to 2000 members in our mailing list. I am using SMTP do you think it is getting overloaded with delivery? Sometimes they would come back with a delivery delayed notification.

I posted my code because there might be something in my program that does not work for mass e-mail sending and somebody might want to give me a suggestion on handling this matter.

What if I send the e-mail one by one instead of doing a bcc?

View Replies View Related

Mass Update Records

I just had a problem where I needed to update a bunch of records from a single form submission. I am sure there are lots of better ways to solve this, but I offer the code I came up with. Also I’m asking if there are any better ways.

The form page had a form in it with a table. Each row in the table had a database record in it. In each row, sat the input field titled “myOrder” and a hidden field called “myID”. The table was a repeat region, so that each field was populated dynamically from each record in the database. The number of records was dynamic in that they increased or decreased by the category the user was in.

The page submitted to my mass_update page.

Here is the relevant part of the code that took each “myID” and “myOrder” data and then updated the database record:...

View Replies View Related

Mass Mailing System

Any body guide me about how to sent 1 lakh email at a time by using cdonts.newmail

View Replies View Related

Mass E-mail Components

I'm going to have a need to send out about 30,000 e-mail messages regularly to addresses that reside in a list/database. (not spam :)

Because of insitutional infrastructure issues on the +receiving+ side, I need to space out the sends: say, send 500 messages, pause ten minutes, send another 500, until the full list of 30,000 is complete.

I'm either going to code this myself, or buy a component that does this for me. Can anyone advise me of a component that can deliberately slow down the processing/sending of an e-mail job? The SMTP stuff will reside on our end.

View Replies View Related

Multiple/Mass Insert

my page(searchresults.asp) will show all the results that you searched for.. These results are from the sql server. All the datas are different. On the right of every record, there is a checkbox.

Now is the scenario..

After all records are shown, I will check a few checkboxes. Then i will click the button. All the data that is checked will be inserted in the sql server. But the thing is that all data records is different..

Its actually kinda off like the hotmail, where you checked a few boxes and put them into a different folder..

View Replies View Related

Best Approach For Mass Mailing

What would be the best approach to sending a mass email out without clogging the server or running the risk that emails maybe lost (possibly due to a timeout).

Currently, I've been given the task with sending out a monthly newsletter to our customers (upon request of course). It is an easy task from what I can tell, simply bcc all the emails, set HTMLBody and TextBody and send it off. But, I will be sending this to 5000 clients and dont want any dropped emails.

Plus, is there a way to determine failed email address (due to bad domain names, bad email address, etc) and report it to the web application?

View Replies View Related

Legal Mass Mailing Problems?

I am web admin for a school's website and now and again I have to send
emails to those who have signed the guestbook and have consented to this.
Now I have a distribution list within outlook but whenever I try to send
these emails I receive different errors e.g. 'too many recipients' Does
using CDONTs to dynamically send emails eliminate this problem? Are you
aware of any cheap programs out there that will meet my needs? I would also
like to be able to easily track and delete the emails that are no longer in
use...

View Replies View Related

Mass Emails, Non-listserv Solution

My client does not want to use a listserv. He wants to send 5000+ emails,
once everyday to our members. Our hosting company has agreed to this.

What are my options here?
I know I can write a basic looping SQL script, but that would take
forever....

What about an "email queue" through SQL? But I cannot install any components
on the web server, so what options are there?

View Replies View Related

Mass Emails To Individual Address

I'm given a DB with everyone's particulars including emails which I'm supposed to retrieve all their emails and do a mass reminder email to the individual email addresses.

I don't want to send a email whereby all the email addresses is shown in the email. Can someone give me some ideas as how am I supposed to go about doing it using asp and vb. Is there any working codes I can refer to?

View Replies View Related

Email From Database

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

ASP Email And Database

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

To Database And Email

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

Send To Database And Email

Can ONE form with ONE submit button send the results to a database and also send the results via email?

View Replies View Related

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 Replies View Related

Email Updating A Database?

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

Email Address From A Database

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 Related

Grab From Database And Send Email

I 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: ....

View Replies View Related

Insert Database Records To Email

How to do i send database information to an html email using ASP?

View Replies View Related

Send Cdo Email With Database Data

i'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 Related

How To Use Href For Email Address Pulled From Database

I 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:

View Replies View Related

Pull Informtion From Database And Send It On Email Id

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.

View Replies View Related

Contact Form Email And Database Insertian

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 Related

Inserting Data To SQL Database And Sending Email At The Same Time?

I’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.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved