Send mail to all the user in the Database Table

Question

0.00/5 (No votes)

See more:

Hello ,,

I want to know how we can send mail to all the user's email id in the database table using button click .

when admin click on the emailsendbutton than the mail sent to all the user

Posted 17-Feb-14 19:14pm

Swinky_Talwar

Add a Solution

5 solutions

Solution 3

Select All user and then write this code in that rdr.read()

VB

Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
        Dim m As MailMessage = New MailMessage()
        Dim sc As SmtpClient = New SmtpClient()

        Try

            m.From = New MailAddress("astikajadhav@gmail.com", "Display name")
            m.To.Add(New MailAddress("astikajadhav@gmail.com", "Display name To")) 'to whom mail have to send
            m.Subject = " This is a Test Mail"
            m.IsBodyHtml = True
            m.Body = "Phone number - "
            sc.Host = "smtp.gmail.com"
            sc.Port = 587
            sc.Credentials = New System.Net.NetworkCredential("astikajadhav@gmail.com", "datta-sudhir")
            sc.EnableSsl = True
            sc.Send(m)


            Response.Write("Email Send sucessfully")
        Catch ex As Exception

            Response.Write(ex.Message)

        End Try

Will work definitely
Any question then ask

Posted 17-Feb-14 19:39pm

astika

Comments

Tom Marvolo Riddle 18-Feb-14 1:43am

Hi astika,OP ask question in C#. Please convert it into c# and update it

Swinky_Talwar 20-Feb-14 4:53am

Convert it into C#

Solution 1

try to read this. . . .

How-To-Send-eMail[__]

Posted 17-Feb-14 19:26pm

The14thNoah

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Accepted Answer · 2014-02-17T19:31:00

For sending mail, you can use System.Net.Mail
Sample is given over here[^].

Now all you have to do is, get all the users from the database, store it in DataTable and then,

C#

foreach(DataRow dr in dt.Rows)   // dt is your datatable
{
    SendMailToClient(dr["Email"].ToString());   // SendMailToClient is a method containing logic of sending mail, and takes email address as a parameter, that can easily fetched from DataTable.
}

Hope the flow is clear to you.
There is a another way for doing this, but once you got the idea, you'll have that as well, for sure :)

-KR

Jubayer Ahmed · Accepted Answer · 2014-02-20T00:39:00

Try this code:

C#

NetworkCredential cred = new NetworkCredential("gmail@domail.com", "Password");
MailMessage msg = new MailMessage();

msg.To.Add("name@domail.com");


            using (SqlDataReader dr = cmd.ExecuteReader())
            {
                while (dr.Read())
                {
                    msg.CC.Add((string)dr["user_email"]);
                }
            }


msg.Subject = "Welcome ME";

msg.Body = "You Have Successfully Entered to Sera's World!!!";
msg.From = new MailAddress("mail@domail.com"); // Your Email Id
SmtpClient client = new SmtpClient("smtp.gmail.com", 587); //SMTP Google
SmtpClient client1 = new SmtpClient("smtp.mail.yahoo.com", 465); //SMTP Yahoo
client.Credentials = cred;
client.EnableSsl = true;
client.Send(msg);

Swinky_Talwar · Accepted Answer · 2014-02-20T00:45:00

C#

 protected void SendMail_Click(object sender, EventArgs e)
{
    cmd3 = new SqlCommand("select email from tbluser", con);
        string email;
        con.Open();
       SqlDataReader dr=cmd3.ExecuteReader();
       while(dr.Read())
       { 
           email=dr[0].ToString();
           MailMessage myMsg = new MailMessage();
           myMsg.From = new MailAddress("*******@gmail.com");
           myMsg.To.Add(email);
           myMsg.Subject = "IPPTA E-library ";
           myMsg.IsBodyHtml = true;
           string currentyear = DateTime.Now.Year.ToString();


           myMsg.Body = "Hello Thanks Your welcome in this World";



           myMsg.CC.Add("******@gmail.com");
           // your remote SMTP server IP.
           SmtpClient smtp = new SmtpClient();
           smtp.Host = "smtp.gmail.com";
           smtp.Port = 587;
           smtp.Credentials = new System.Net.NetworkCredential("*****@gmail.com", "Password");
           smtp.EnableSsl = true;
           smtp.Send(myMsg);
       }
}

Send mail to all the user in the Database Table

5 solutions

Solution 2

Solution 3

Solution 4

Solution 5

Solution 1

Add your solution here

Preview 0