Try this:
Namespaces:
using System.Collections;
using System.Data.SqlClient;
using System.Net.Mail;
Code:
private void btnSend_Email_Click(object sender, EventArgs e)
{
ArrayList list_emails = new ArrayList();
int i = 0, email = 0;
sqlConnection1.Open();
SqlCommand cmd_Email = new SqlCommand("Select Email from Email_Table", sqlConnection1);
SqlDataReader read_Email = cmd_Email.ExecuteReader();
while (read_Email.Read())
{
email = read_Email.GetValue(i).ToString();
list_emails.Add(email);
i = i + 1 - 1;
}
read_Email.Close();
sqlConnection1.Close();
foreach (string email_to in list_emails)
{
MailMessage mail = new MailMessage();
mail.To.Add(email_to);
mail.Subject = "Welcome to C#";
mail.From = new MailAddress(hold_Account);
mail.Body = "Test";
SmtpClient smtp = new SmtpClient("SMTP Server");
smtp.Send(mail);
}
Ref.: send email to multiple email addresses [^]