How To send Email to all Registered User E-mail ID in ASP C#

Using System.Net.Mail
protected void SendMail()
{
//Mail notification
MailMessage message = new MailMessage();
message.Subject = "Email Subject ";
message.Body = "Email Message";
message.From = new MailAddress("[email protected]");
// Email Address from where you send the mail
var fromAddress = "[email protected]";
//Password of your mail address
const string fromPassword = "password";
// smtp settings
var smtp = new System.Net.Mail.SmtpClient();
{
smtp.Host = "smtp.mail.com";
smtp.EnableSsl = true;
smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
smtp.Timeout = 20000;
}
SqlCommand cmd = null;
string connectionString = ConfigurationManager.ConnectionStrings["DbConnectionString"].ConnectionString;
string queryString = @"SELECT EMAIL_ADDRESS FROM EMAIL WHERE EMAIL_ADDRESS = EMAIL_ADDRESS";
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlCommand command =
new SqlCommand(queryString, connection);
connection.Open();
cmd = new SqlCommand(queryString);
cmd.Connection = connection;
SqlDataReader reader = cmd.ExecuteReader();
// Call Read before accessing data.
while (reader.Read())
{
var to = new MailAddress(reader["EMAIL_ADDRESS"].ToString());
message.To.Add(to);
}
// Passing values to smtp object
smtp.Send(message);
// Call Close when done reading.
reader.Close();
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Srikant Maruwada8y ago
Accepted answer
HiChandan,

Please refer below article .

http://www.c-sharpcorner.com/UploadFile/ee01e6/create-windows-service-and-send-mail-daily-on-fixed-time-usi575/
0
Bharathi Raja8y ago
1. Using System.Net.Mail
3. protected void SendMail()
4. {
6. //Mail notification
7. MailMessage message = new MailMessage();
8. message.Subject = "Email Subject ";
9. message.Body = "Email Message";
10. message.From = new MailAddress("[email protected]");
12. // Email Address from where you send the mail
13. var fromAddress = "[email protected]";
15. //Password of your mail address
16. const string fromPassword = "password";
18. // smtp settings
19. var smtp = new System.Net.Mail.SmtpClient();
20. {
21. smtp.Host = "smtp.mail.com";
22. smtp.EnableSsl = true;
23. smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
24. smtp.Credentials = new NetworkCredential(fromAddress, fromPassword);
25. smtp.Timeout = 20000;
26. }
27. SqlCommand cmd = null;
28. string connectionString = ConfigurationManager.ConnectionStrings["DbConnectionString"].ConnectionString;
29. string queryString = @"SELECT EMAIL_ADDRESS FROM EMAIL WHERE EMAIL_ADDRESS = EMAIL_ADDRESS";
31. using (SqlConnection connection =
32. new SqlConnection(connectionString))
33. {
34. SqlCommand command =
35. new SqlCommand(queryString, connection);
36. connection.Open();
37. cmd = new SqlCommand(queryString);
38. cmd.Connection = connection;
40. SqlDataReader reader = cmd.ExecuteReader();
42. // Call Read before accessing data.
43. while (reader.Read())
44. {
46. var to = new MailAddress(reader["EMAIL_ADDRESS"].ToString());
47. message.To.Add(to);
49. }
51. // Passing values to smtp object
52. smtp.Send(message);
54. // Call Close when done reading.
55. reader.Close();
56. }
57. }
0