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
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?
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:
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.
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"
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:
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:
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
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?
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?
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?
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 ?
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.
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 "
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. " %>
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
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.
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??
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:
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?
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>
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?
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!)
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.
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.