Email Multiple Recipients From Recordset (jmail)
I'm trying to send an email (jmail) to everyone in a recordset but I'm getting no joy,I keep getting a "not all servers received message" error or something similar, can someone please take a look at this code and see if they can spot my glaring errors ?
<%
set rsetReminder = Server.CreateObject("ADODB.Recordset")
rsetReminder.ActiveConnection = MM_connmessages2_STRING
rsetReminder.Source = "SELECT * FROM accessgroups WHERE ((accessgroups.fldjoined<Date()-14)) AND fldGroup = 'Guest' ORDER BY fldjoined DESC"
rsetReminder.CursorType = 0
rsetReminder.CursorLocation = 2
rsetReminder.LockType = 3
rsetReminder.Open()
rsetReminder_numRows = 0
%>
<%
While NOT rsetReminder.EOF
firstname = rsetReminder.Fields.Item("fldFirstname").Value
lastname = rsetReminder.Fields.Item("fldLastname").Value
emailadd = rsetReminder.Fields.Item("fldEmailAddress").Value
username = rsetReminder.Fields.Item("fldusername").Value
password = rsetReminder.Fields.Item("fldPassword").Value
usrid = rsetReminder.Fields.Item("fldnewuserid").Value
crlf=chr(13)+chr(10) .....
View Replies
ADVERTISEMENT
I'm a PHP programmer who for some reason was tasked with fixing some code on an asp page. I have what I feel should work, but I am getting this error:
CDO.Message.1 error '8004020c'
At least one recipient is required, but none were found.
/admin/mass_email_monthly.asp, line 47
Line 47 being this line: objMessage.Send
Now I want to have multiple recipients pulled from the database as illustrated in the code, but it isn't working. I have no idea why, and I have no idea what that error message means? Can anyone point me in the proper direction of a tutorial that can help? OR possibly show me where my syntax is wrong?
View Replies
View Related
I have a Jmail form with several texfields incl. email and name of users. The mail is sent from me "John Doe" "email@domain.com" to the user filling out the form. When the e-mail is being sent it looks like this: Code:
View Replies
View Related
I have a form that I want to email three people from - dependant upon three fields in a form.At the mo, I can only email 1 person.it doesn't work
Set iMsg.Configuration = iConf
iMsg.To = Request.form.Item("Room") & Request.form.Item("student") & Request.form.Item("teacher")
View Replies
View Related
I'm sending email using ASPMailer thru ASP to single recipient, it is working fine. But if i m sending to multiple recipients its not working, email is going but not in proper format. i am sending some HTML format email. the email received by recipient if getting junk not in proper format.
View Replies
View Related
I have few textboxes on my first page that ask for user's e mail address and other five additional e mail address after submiting that form it sends a copy to all the people use e mail address is entered.
I can send e mail to only one person if i put following code
objCDOMail.Cc = "viral007@gmail.com
or
objCDOMail.Cc = Emailtxtfield
but how can i send e mail to all the people on the list
it works if i put this
objCDOMail.Cc = "viral007@gmail.com; viralbhatt@hotmail.com"
but i have to get the value from txtbox
so if i put this code
objCDOMail.Cc = Emailtxtfield; Emailtxtfield2
it doesn't work.
View Replies
View Related
I'm using cdo to send auto-generated emails. I'm calling a stored procedure that returns a recordset.
In most instances, the recordset will only return one record containing one email as the value. However, there are instances, where two records can be returned with two seperate email addresses that I need to send out using cdo. This is how I'm calling the procedure:
Code:
View Replies
View Related
I am using CDONTS to send a confirmation email. I am using plain text to send my email. I would like to send to multiple users, but I am already using the "To," "Cc," and "Bcc." Is it possible to send to multiple recipients in the "To" field? I am also using variables instead of hard coded email addresses. Here is my code:
Set MyCDONTSMail = CreateObject("CDONTS.NewMail")
MyCDONTSMail.From= TeacherEmail
MyCDONTSMail.To= Administrator, Administrator2, Administrator3
MyCDONTSMail.Cc= Secretary
MyCDONTSMail.Bcc= TeacherEmail
View Replies
View Related
somebody can whats wrong with my script, i would to add some additional recipients on the cc field, what would i do? Code:
View Replies
View Related
how can i send the mail (CDONT) to multiple recepients in ASP
if i select the address from the address box ,then all the selected mail id will go to TO text box with ' seperator.
View Replies
View Related
ASPEmail to send to multiple recipients? I tried to use comma and semicolon but all the time give this message error:
Error: 6 - 501 Bad address syntax
nor : email@dom,email@dom,email@dom
or: email@dom;email@dom;email@dom
what is the sintaxe for it? can I only send for one recipient by time?
View Replies
View Related
I can get it to work with following code:
<%
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "smtp.stormvision.co.uk:25" ' change this to your mail server
JMail.Sender = "a@p.com"
JMail.Subject = "Enquiry"
JMail.AddRecipient("marcus@stormvision.co.uk") 'here type in your email address again
JMail.Body = ("Email : " & Request.Form("Mailto") & vbcrlf)
JMail.appendtext("Full Name: " & Request.form("Name") & vbcrlf)
JMail.appendtext("City : " & Request.form("City") & vbcrlf)
JMail.appendtext("Telephone : " & Request.form("telephone") & vbcrlf)
JMail.appendtext("Postcode : " & Request.form("postcode") & vbcrlf)
JMail.appendtext("Comments : " & Request.form("comments") & vbcrlf)
JMail.Priority = 3
JMail.Execute
%>
The trouble is says that every email is from a@p.com
So i modified the JMail.Sender line to
JMail.Sender = Request.Form("Mailto")
But am struggling to make it work.
View Replies
View Related
I had a problem with my webspace provider and CDONTS so I gave upon that front. I am now trying JMail which seems to be working, so now I need to transfer all my formatting from CDONTS to JMail.
I have a question on the formatting of a Jmail email.
I have the following snippet of code which details the variables and contents of the body of the email
body = "Name:- " & Request.Form("firstname") & " " & Request.Form("surname") & "<p>" & Request.Form("number") & "</p>"
I want to insert a line break/paragraph between Request.Form("surname") and Request.Form("number"). As you can see I have tried dong this with <p> tags and also <br>'s. However the tags are outputted into the email and not acutal line breaks.
Any ideas as to how to format the body of the email?
View Replies
View Related
I use jmail to send email. Version 3.7. I want to send hyperlink in the mail body with sessionid variable. But I dont know how to concatenate it.
Here is the example which dont work.....
View Replies
View Related
I am testing JMail through ASP on my local server so I can just swap out serverAddress when it goes live to make a simple switch with our live server.
However I KEEP getting :
The message was undeliverable. All servers failed to recieve the message
jmail.dll was installed into windows/system32 and regsvr32 jmail.dll was successful.
Here's the code; I specified :
localhost:25
mail.locahost:25
mail.localhost.com:25
127.0.0.1:25
all with and without the :25 on the end. No go. Same error. Here's my code :
View Replies
View Related
Basically I have the following SQL statement:
Quote: sqlConnect = "SELECT Users.User_ID, Users.Password, Users.Username, Event.Event_ID FROM Users LEFT JOIN Event ON Users.User_ID = Event.Admin_ID where Username = '" & Username & "'"
set rs= Server.CreateObject ("ADODB.Recordset")
rs.open sqlconnect, objconn, 3, 3
where username is an ASP variable of the username.
When I run this and I try to access a field from event I get an error i.e.
Quote: if rs("Event.Event_ID")<>")" then
session("admin")= rs("Event.Event_ID")
end if
Does anyone know what is wrong?!?!?! It doesn't seem to be able to pick up the fields from the event table?
View Replies
View Related
My database has customers, orders, and orderDetails tables. I'm trying to create a page that we can access to lookup all details about our orders. That page will need information from all of these tables.
How do I create a recordset that can handle the relationships and bring in all data?
View Replies
View Related
I know how to read data from an MS Excel file, just as if i amreading it from an Access DB with recordsets and stuff like that.
Want i'm wanting to know is:
is there a way to export 2 different recordsets that I have loaded into 2 different "sheets" within the one Excel file
I can export 1 or more recordsets to 1 Excel sheet, but I really need to export them to individual sheets in the same Excel file.
View Replies
View Related
Users enter data using HTML forms and it gets processed by an asp page that enters the data into the database. What I am trying to do is get a "confirm" page set up that will make sure the form was completed properly. If it is completed successfully, then the data from the form needs to be forwarded onto another asp page that will enter the data into the database.
My question is, what is the best way to forward the information on? Currently I am using querystring to handle this, but that doesn't work in some situations especially when one of my forms has a <textarea> box that seems cumbersome to send via querystring.
Is there a method I can use to easily forward the data from the form to subsequent pages after the first one ?
View Replies
View Related
I would like to dulicate a selected record. Sounds easy enough like performing another INSERT operation. However, that solution only works if the datasource is only one table.
I have 4 different tables all linked to the main table through a unique primary key (auto number). When a user clicks a button to clone a record, all related records from the other tables must also be duplicated using the newly assigned ID that matches the one from the main table.
Hopefully I didn't confuse you. Consider it like a multi-step process of filling out different web-based forms but using the same unique id.
I don't know the first place to start on creating duplicate entries based on existing records. If you can start me with the code, I could probably follow the logic. THe difficult part for me to conceptualize is how to carry this new ID to all the other tables.
View Replies
View Related
the script works but i wanna have this email to be sent to more than one recipient (see below code in red). I did add another ObjMail1.To tag for another email recipient but doesnt work.
<%Response.Buffer=True%>
<html>
<head>
<title>Thanks</title><%
Dim salutationname,salutation,t1name,t1,t2name,t2,t3na me,t3,t4name,t4,highqualificationname,highqualific ation,checkname,check,MyNewRandomNum
Randomize
MyNewRandomNum = Round(Rnd * 100000000000)+1
salutationname = "Salutation"
salutation = Request.Form("salutation")
t1name = "Name"
t1 = Request.Form("t1")
t2name = "Telephone number"
t2 = Request.Form("t2")
t3name = "Email"
t3 = Request.Form("t3")
t4name = "Age"
t4 = Request.Form("t4")
highqualificationname = "Qualifications"
highqualification = Request.Form("highqualification")
checkname = "Options"
check = Request.Form("check")
Dim stname,st
stname = "Comments"
st = Request.Form("s1")
Dim ObjMail1,ObjMail2
Set ObjMail1 = Server.CreateObject("CDONTS.NewMail")
'CHANGE THE EMAIL ADDRESS IN QUOTES BELOW TO THE ADDRESS YOU WANT THIS MAIL SENT
ObjMail1.To = "info@abc.com "
ObjMail1.From = t3
ObjMail1.Subject = "Enquiry"& "" & "QUEUE NO: " &Trim(MyNewRandomNum)& ""
ObjMail1.Body = t1name & vbcrlf&_
t1 & vbcrlf&_
t2name & vbcrlf&_
t2 & vbcrlf&_
t3name & vbcrlf&_
t3 & vbcrlf&_
t4name & vbcrlf&_
t4 & vbcrlf&_
highqualificationname & vbcrlf&_
highqualification & vbcrlf&_
checkname & vbcrlf&_
check
ObjMail1.Send
Set ObjMail1 = Nothing
Set ObjMail2 = Server.CreateObject("CDONTS.NewMail")
ObjMail2.To = t3
ObjMail2.From = "info@abc.com"
ObjMail2.Subject = "Thanks for your enquiry."& "" & "Your QUEUE NO: " &Trim(MyNewRandomNum)& ""
ObjMail2.Body = " Hello " &"" & t1 & ".You have submitted your enquiry to us. You will hear from us shortly. " & "" & ":" & st &""
ObjMail2.Send
Set ObjMail2 = Nothing
Response.Write"<center />Thank You.You will hear from us soon. "
%>
</head>
</html>
View Replies
View Related
I'm sending mail using below code. It works fine. How can I send email to more than one address. I wanna add one more address in .to feld or in .cc
Set cdoMessage = Server.CreateObject("CDO.Message")
With cdoMessage
Set .Configuration = cdoConfig
.From = "abc@abc.com"
.To = "xyz@xyz.com"
.Subject = "abc"
.HtmLBody = body
.Send
End With
View Replies
View Related
I have an html page with standard contact us type form. This when posted goes to an asp page which stores the data and then sends an email to me. It then redirects back to the original email form with a message thanking the user for the contact.
The problem is I am getting multiple spoof emails which are being generated form the asp page. Some one is accessing and then just refershing the page so it generates numerous emails.
Is there a way of either hiding the asp page in the original HTML form or checking that the page has been called by the html form rather than just refreshed.
View Replies
View Related
i've finally integrated a way to send multiple attachemts from within an asp page and it works!!!!!
View Replies
View Related
Just want to confirm if you can add multiple attachments like this? Code:
Mail.Host="test@yahoo.com
Mail.FromName="test@yahoo.co.uk"
Mail.AddAttachment "C: est.doc"
Mail.AddAttachment "C: est2.doc"
View Replies
View Related
I could sure use some conceptualization and query help with a Page Watch
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that
notifies a person of yacht(s) that have changed on our website:
Key database tables.....
View Replies
View Related
Here's the script I'm using now to send me a picture selected in a form (from a browse button type thing), sent to me in the attachments.
Right now it will only send the one picture (field name="Attachment"), how can I change this script to send multiple (for example; ten) pictures in the attachments from the form??
Here's the script...
View Replies
View Related
I am using this script to submit my form fields into the body of my email:
***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next
***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
View Replies
View Related
I'm using CDO Message to send out a newsletter, but I want to keep the recipient list hidden from view in the email TO: field and just show <undisclosed recipients>
How can I accmplish this? Code:
View Replies
View Related
I have a standard formmail contact form that I would like to customize the recipient on. In other words, I want to be able to specify the recipient in a string in some cases, but when it is not specified have it send to a default recipient. What's the easiest way do accomplish this?
View Replies
View Related
I have a database of 2000 subscribers. I need to send an HTML email to the entire list, but the mail needs to be individual to each recipient, so I need to loop through a script integrating database results into the mail-out.
My host doesn't have any ASP email components installed on the server other than CDOSYS.
Will CDOSYS be able to handle this, or will it flake/timeout? I need to be sure that when my colleague presses 'the button' it works (I'll be on holiday at the time!)
View Replies
View Related
I use CDOsys and this code to specify the recipient. I guess I could create two separate instances of the objMail and specify everything one more time, but I want to send mails to two persons at once (the recipient and myself) and therefore wonder if there is a shorter way to do it.
View Replies
View Related
I retrieve data from a database and I put the data into an array. Afterwards I want to send these data as an email using JMail. The problem is that I receive the following error when I am trying to send the email: Variable uses an Automation type not supported in VBScript. On the other hand if I try to print them on the screen there is no problem.
View Replies
View Related
