build a maillist

danyseb · Joined: 29 Nov 2005 Posts: 1

hi i am new programing.. now i do a maillist send but for send i need to chosse a mail in my dropdownlist. WHAT CODE I NEED TO WRITE FOR THAT EVERY MAIL FOUND AT MY TABLE MAIL EXECUTE THIS FUNCTION ... BECAUSE I WANNA THAT MAILLIST WORKS SENDING MAILS TO ALL SUSCRIBERS.
can you understand my Idea ?

void SendNewletter(Object s, EventArgs e) {
MailMessage objMail = new MailMessage();
objMail.From = "mi@mi.com";
objMail.To = ddlto.SelectedItem.Text; // <<<-- HERE!!!!!!!!!
objMail.Subject = txtSubject.Text;
objMail.BodyFormat = MailFormat.Html;
objMail.Body = "<html><head><title>" +
HttpUtility.HtmlEncode(txtSubject.Text) +
"</title></head><body>";
objMail.Body +="<img src=\"http://localhost/images/" + "logo.gif\" />";
objMail.Body +="" +
HttpUtility.HtmlEncode(txtIntroduction.Text) + "";
objMail.Body += "Employee of the month: " +
HttpUtility.HtmlEncode(txtEmployee.Text) + "";
objMail.Body += "This Months featured event: " +
HttpUtility.HtmlEncode(txtStoreItem.Text) + "";
objMail.Body += "</body></html>";
SmtpMail.SmtpServer = "localhost";
SmtpMail.Send(objMail);
lblResult.Text = "The Newsletter has been sent!";
}

not , i now using a dropdownlist, i have a checkbox that says "all senders" , i want to check this and do clic on "send mail" and system check that checkbox is market send mail to every mails of datatable.

i hope you can helpme
_________________
i am here.. but i dont feel..

administrator · Site Admin Joined: 01 Oct 2004 Posts: 183

You can select all emails in your table into a recordset, and then add them as recepients within a loop. Something like that:

sSQL = "SELECT Email FROM tblEmails"
Set oRS = oConn.Execute(sSQL)

While Not oRS.EOF

sMailTo = sMailTo & oRS("Email") & ";"

Wend

Set oRS = Nothing

objMail.To = sMailTo
_________________
Peter
ASP & ASP.NET Articles and Tutorials