Sending mail to multiple person

Question

Hi friends I want to know that I am working with ASP.NET then how we will send an Email to the multiple person but the Email_id should read from the M/S Access database? If anyone knows that how it is possible to do that please tell me?

Senthilkumar · Answer

Hi You need to load the data from the database and keep the result in the DataTable or custom collections or Arrays. You need to include the System.Net namespace for sending the emails. //Create an object of MailMessage class MailMessage message = new MailMessage(); //Assign the MessageFromEmailID i.e. sender's EmailID message.From = new MailAddress(sender@domain.com); //Add the MessageToEmailID i.e. recipient's EmailID message.To.Add(new MailAddress(recipient@domain.com)); //Assign the subject of the email message.Subject = Email Subject; message.IsBodyHtml = true; //Assign the body of the email i.e. the message to be sent message.Body = Message to be sent; //Create an object of SmtpClient by passing ur SMTP Server name and SMTP port to be used. By default port 25 can be used. SmtpClient objSMTP = new SmtpClient(SMTPHost SMTPPort); objSMTP.UseDefaultCredentials = true; //Call the Send method of SmtpClient object and pass the MailMessage object while will finally send the email message to the recipient's emailID objSMTP.Send(message); The marked in the bold letter is the place to add the recipient mail address. If you want to send in one shot then you need to iterate the db list users email id in the message.To.Add property. If you have string array then foreach (string ccRecipientEmailID in arrAllCCRecipients) { message.CC.Add(new MailAddress(ccRecipientEmailID )); } If you have DataTable then foreach (DataRow dr in dtEmailUsers.Rows) { string emailId = dr[EmailID].ToString(); message.CC.Add(new MailAddress(emailId)); } If you want to more details then: http://www.etechplanet.com/blog/how-to-send-email-in-an-aspnet-web-application-using-c.aspx