CDO Bulk Email

Novice here, I am doing bulk emails using CDO, connection to a smtp
server at another location. I am trying to streamline my script, or
through it out and start over to make it faster.

I know that I am doing something wrong and that messages should be
sending much faster.

Set objConfig = Server.CreateObject("CDO.Configuration")
Set Fields = objConfig.Fields

With Fields
.Item(cdoSendUsingMethod)= cdoSendUsingPort
.Item(cdoSMTPServer) = "blah.com"
.Item(cdoSMTPServerPort) = 25
.Item(cdoSMTPConnectionTimeout) = 10
.Item(cdoSMTPAuthenticate) = cdoBasic
.Item(cdoSendUserName) = "blah@blah.com"
.Item(cdoSendPassword) = "blah"
.Update
End With

Set objMessage = Server.CreateObject("CDO.Message")
Set objMessage.Configuration = objConfig

' Open database here

objRS.Open SQLString, objConn,2,2
I = 0
With objMessage
.From = "Blah Mailer <blah@blah.com>"
.Subject = Request.Form("Subject")
.TextBody = Request.Form("Body")
Do while not objRS.EOF
.To = objRS("Name") & "<" & objRS("Email") & ">"
.send
objRS.MoveNext
I = I + 1
Loop
End With
objRS.Close
objConn.Close
Set Fields = Nothing
Set objMessage = Nothing
Set objConfig = Nothing

View Replies


ADVERTISEMENT

SOS! Bulk Email With Cdonts

I am building a web script that will enable a user to compose an email and send it to potentially thousands of subscribers on their mailing list from a DB. The ASP script will use CDONTS or Jmail.

Problem is that I told my host about the app and they say they only allows 1000 emails to be sent daily from my server. The script will possibly send thousands of emails daily. Any body have experience with using ASP for bulk emailing, and how to get around server limitations?

View Replies View Related

Bulk Email Advice

my web host offers ASPMail - which works fine for sending individual emails, but I'm not too keen on using it to send out bulk emails because generally it times out, and then I am left with having to work out who has received their email, and who hasn't.

Anyway, just checking to see if anyone here has any advice about what options I could use to send out bulk emails. My idea of "bulk" is anywhere between 300 and 1400 at a time.

I know there are lots of free services on the web out there which offer free email newsletter services - do people have any recommendations for any of these, or any ASP based components or scripts which I could use on my site to get around this problem?

View Replies View Related

Creating Bulk Email Through Cdosys.dll

is it possible to rn a client side vbscript to send messages using cdo.message and cdo.configuration? what are the requirements to do this? my wks are xp and 2000 and all have cdosys.dll registered. do i have to have outlook express loaded.

i have workstations that don't have outlook but rather lotus notes and want to send email to an smtp server. these emails have local attachment thus the need to run client script versus server scripts. is this possible or am i on the wrong track.

View Replies View Related

ASP Bulk Emailing

I am currently working on script which needs to be able to send personalized emails.

The number of emails needing to be sent at one time could be anywhere from 100 to 100,000.

I would like to provide this as a background process. IE The administrator clicks on the "Dispatch Emails" button, is able to continue with his work, and then sometime later a popup windows shows up telling him the emailing was successful.

The script is currently using a sendmail function using CDONTS. Will this be able to handle a large number of emails? What about being able to somehow have the sendmail functioning in the background?

I have never worked with ASP send mailing features before and I guess I am looking for suggestions as to how i should go about this.

View Replies View Related

Bulk Inserting

I have an error as follows:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not bulk insert. File 'c:mydata.csv' does not exist.

My mydata.csv file is inside the directory i stated. But why does the server complains that the file is not fould?

My codings:

strSQL = "BULK INSERT NAME FROM 'c:mydata.csv' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR =

'
')"

Response.Write ("test")
Set oRS = conn.Execute(strSQL)

View Replies View Related

Bulk Updates

I have an Employee Database in MSAccess with more than 10 tables. The updates of employee is done frequently and is done in bulk. The fresh data arrives in Excel worksheets (more than 50 records).

I have created a user interface in ASP to update these records in Access. But the user ends up doing more work updating. Importing Excel worksheets to Access is one way ...but then the column names and types have to be adjusted evrytime.

Can i build a datagrid in browser using ASP, so that the whole table gets displayed and the user can update the data in bulk. And is there any way I could copy paste the Excel records in such datagrid?

View Replies View Related

Bulk Emailing

I need to send an email out to about 800 members of our organization once every month. I've been using a 3rd party listserver, but that's been cumbersome at best, trying to keep the two email databases in sync and all.

I know how to write an asp loop to query our database and send an email to each of the 800 recipients, but I'm not sure if this is the right approach. We have an sql-driven website that's tied in as well, so ideally what I want to do is use asp to grab some website data from the sql database, generate the email text, then cycle through our membership database sending it to each member. Is this a good method, or what would be a better approach?

View Replies View Related

Sending Bulk Emails

I have a Client Mailer page which basically sends emails off containing information specific to each client = email address found in the relevant database. I basically get this to simply loop through the client recordset (recordset.moveNext), and on each loop it sends an email to the relevant email address via CDOSYS.

Can I just check that this is ok, and this could :

a. Not have a maximum amount of clients this could send to, and basically be too much for the page to cope with if there were too many clients to loop through?

b. This could not cause some sort of Email block due to the server thinking it is spamming, etc.?

This was something someone mentioned, which I just wanted to check out!, as they suggested changing it to a Javascript refresh page, whereby it will send an email every 6 seconds for example by refreshing the page with Js, but I don't really want to change it to this unless I have to... as I was hoping the way in which I have it with the recordset loop, that it would be ok.

View Replies View Related

CDO Attribute For Bulk Mail?

I was wondering if there was a CDOSYS attribute to mark the importance of mail messages. I'd like to set their importance to "80" so the CDO Generated messages are treated as low priority by my mail server.

I was wondering if their was an configuration attribute like the following which I could use.

ObjMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing")=2
ObjMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") ="mail.domain.com"
ObjMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport")=25
ObjMessage.Configuration.Fields.Update

View Replies View Related

Bulk Insert - .dbf File


Can we use BULK INSERT for .dbf files

View Replies View Related

Sending Bulk Emails

We are having large database of 3000 emailids and we want to send the newsletter to all these ids at a time. The program works for 20 to 30 email ids but when we are trying to send for 3000, the page cannot be displayed error is coming. When it is run in local system server.scripttimeout error is coming and the mail is going to 2000 mailids.

View Replies View Related

Bulk Upload Of Files Using Persits

how can i upload all the files of a folder which is selected by the user using persits.upload

View Replies View Related

How To Prevent Duplicate Values When Using BULK INSERT To Insert CSV To SQL Server?

How to prevent duplicate values when using BULK INSERT to insert CSV to SQL Server? Code:

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

CDONTs - Problem Formatting An Email, From Form To Email

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

View Replies View Related

Generating Email Address And Textarea To Be Inlcluded On Email

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:

View Replies View Related

Asp Email Verification Check Valid Email Thru Mx Record

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.

View Replies View Related

Cdonts Email Script Won't Send Email

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

%>

View Replies View Related

Email Form - Verify Email Address

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?")

View Replies View Related

ASP Email Form: Sends To Some Email Addresses But Not Others..

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?

View Replies View Related

Email Through CDONTS Using ISP Email Server

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".

View Replies View Related

Remove Email Address/ Pseudo Email Address

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.

View Replies View Related

Com + Email

I'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?

View Replies View Related

Email

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 Related

Email CDO

can you use free email accounts (hotmail. yahoo) too send emails with CDO?

View Replies View Related

Email

Is 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 Related

Email To All

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

Email + CDO

I 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

View Replies View Related

Email Via ASP

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 Related

From Csv To Email

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

View Replies View Related

Email

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

View Replies View Related

Email In 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")

View Replies View Related







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