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
ADVERTISEMENT
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
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
View Related
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
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
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
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
Can we use BULK INSERT for .dbf files
View Replies
View Related
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
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
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
how can i upload all the files of a folder which is selected by the user using persits.upload
View Replies
View Related
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
I've got a form which people will fill out on the web with information such as there name, email address etc.
Ive got it to email through to me but any ideas how i can also get it to email a message back to them based on the email address they place in the email field?
View Replies
View Related
I am having problems emailing an ASP page within the body of the email.Is there an easier way than using CDONTS to accomplish this?
Here is what i have so far:
objBody="/download.ASP"
Set objCDO = Server.CreateObjec("CDONTS.NewMail")
objCDO.From = "asj1297adv@yahoo.com"
objCDO.To = "asj1297adv@yahoo.com"
objCDO.Subject = "Testing"
objCDO.Body = objBody
objCDO.BodyFormat = 0
objCDO.MailFormat = 0
objCDO.Send
What i end up getting is an email with the following as the contents of the body "/download.ASP". Is there an easy way to assign an ASP page to a variable and send it through email.
View Replies
View Related
I need the following code to send all fields in a text format to an email address directly from the Win XP IIS personal webserver. Code:
View Replies
View Related
We have stored user registration information in an Access database, and we wish to develop an email with attachments like words document and pictures in jpeg/gif format and import mailing list from the Access database and to send this to the user .
View Replies
View Related
I need to send batch html emails out from a db mailing list (anything up to 1000 in one go).I am using CDOSYS and standard ASP. My problem is that it will error if I try to do any more that 5 every 30 seconds - this is fine when I send them out myself (I have a script to do this) but now I need a program which will allow users to send out batches and I want it to appear seamless.
View Replies
View Related
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
i'm still kind of new to ASP all together but i need to make a web form which will email the information to a specified email address. i've gotten the form to work flawlessly. however, i would like to add an attachment field so the user can upload attachments for us. how do you code attachments? our server is currently using CDONTS.
View Replies
View Related
I have the xhtml code below:
<label>Languages Spoken </label>
<input type="checkbox" name="chk_english" value="English" />
English
<input type="checkbox" name="chk_poruguese" value="Poruguese" />
Poruguese
<input type="checkbox" name="chk_french" value="French" />
French
<input type="checkbox" name="chk_spanish" value="Spanish" />
Spanish
<input type="checkbox" name="chk_italian" value="Italian" />
Italian
Could anyone tell me how to code in asp the CDO emailing sending stuff for check boxes.
I can do text, list boxes, radio buttons but im unsure how to link in a check boxes are they all stand alone elements liek text boxes?
View Replies
View Related
I was wondering if someone could help me out. I have a form and what I want is to have only certain parts of the form be emailed out to certain people.
So say I have 2 sections of my form. I want section 1 to be emailed to person1@host.com and I want section 2 to be emailed to person2@host.com.
I already have a very crude code to send out an email for the entire form to 1 person. Can anyone help me with this?
View Replies
View Related
I am trying to email form contents using ASpmail. I have gotten the form to email the contents, however, when the email is received the contents are in a very random order. Is there a way to get the information in the email to appear in the same order in which the form fields appear on the form page?
View Replies
View Related
I have different templates for different companies to be sent to the customer. first i get all the templates from the DB by giving: Select templates from tempates;
Now i want the user to select one..may be we can have a radio button displayed near the textarea in which i will be displaying the templates from DB. Once the agent selects one of the templates to be sent,that template should be sent as an email to the customer.
How do i go on achieving this ,with good formatted template in the DB?
View Replies
View Related
I believe that the SMTPMail component is part of ASP.NET, although I may be wrong, but is there anyway of using it in normal ASP scripts??
I ask because I need to send an email via my script, to a preset email address and containing the same message each time it is sent, and I have my own SMTP server (linux based) which I would like to utilise.
I also cannot use CDOSYS for this, tried everything but cannot get it to work on my machine
Failing that, does anyone know of a freeware component that will enable me to put normal SMTP commands into my scripts, just so I can send an email to a specified address, containing a basic body and using the SMTP server I have.
View Replies
View Related
I was wondering, is it possible to send the results of a web form through email instead of storing it in a database ?
would it be done it such a way
Code:
<form ACTION="mailto:aymenz@company.com" METHOD="POST" ENCRYPE="text/html">
also can i use both: store in the database and email the results of this webform to 2 reciptients, the buyer and the seller
View Replies
View Related
I have a form with two textfields. When the user hits the submit buttom I want the server to email me the results from the textfieds. Can anyone help me with this?
View Replies
View Related
I need the ability to email the output of an asp page to someone. I've seen it around enough that I'm guessing it's pretty basic, but I haven't come up with the google search that'll get me what I need.
I know how to send an html email, but I can't figure out how to get the contents of that page into a variable. The pages I want to send are like this one: Code:
View Replies
View Related
I have a SQL statement that returns the following list:
Email | Client_ID | Search | Description
test@test.com | 1 | chevrolet | chevrolet, in new condition
test@test.com | 1 | chrysler | very nice chrysler, $ 500
mail@mail.com | 2 | chrysler | good chrysler as new
Email = e-mail address
Clienst_ID = ID of the client
Search = Keyword that a client entered in the database to search for Description = The result from the database based on the keyword. Code:
View Replies
View Related
I have these email forms (using CDO) that email the content of a form to different people in our organization. Now I'd like to also email the user after they initially submit the form to confirm that we've received their information and advise them of the next steps.
My problem is that I'm trying to create 2 email instances on 1 asp page I think... which I guess is 1 session?? I'm kinda lost. How can I generate two seperate emails from one form submission? Of course, my first attempt was to just copy the original email code and change the variable names... but that doesn't work... it gets stuck on setting up the CDO config.....
View Replies
View Related
I have an asp page that successfully writes out the form data to a text
file. I would like to use Blat (or other free email utility) to send
the contents of the text file to a user. The code to email is as
follows:
Dim stdout, shell, cmd
function ExecCmd(cmdline)
set stdout = wscript.stdout
set shell = createobject("wscript.shell")
set cmd = shell.Exec(cmdline)
do until cmd.status=1: wscript.sleep 5:loop
ExecCmd = cmd.stdout.readall
End Function
ExecCmd("blat .prodapp.txt -s "Product Info" -t Join Bytes!")
I am guessing that it may not like the two sets of double quotes. Is it
possible to do this? The company is not willing to spend $$$$$ on
actual sendmail package.
View Replies
View Related
I'm trying to build a page that the user can attach a file/s to and email them thru a form. I see plenty of info on how to actually code it to send with a variable - but how do you build a form that allows user go out and browse for a file? Then loads the path into a form?
View Replies
View Related
I have created a form in HTML with no problems, but I can't find any tutorials on how to (or whether I even can) have the results of what the user inputted into the form directly to me. I would also like to be able to have the results stored in an Excel Spreadsheet as well. I've found tutorials on how to send to addresses inputted into the form, kind of like a 'Thanks for Participating' sort of thing and I've tried to modify it to get it to work for sending me messages, but I just can't get it to work.
View Replies
View Related
