Sending E-mail to All List of Users with ASP.NET and MS SQL 2008 database

Question

0.00/5 (No votes)

See more:

Hi All,

The main scope of my task to create the email functionality to send the e-mail to every each user separately but it sends to all users(all user names are display in To property. Having a problem to accomplish this.

Here's the fragment on the code:

C#

ArrayList list_emails = new ArrayList();
    int i = 0;
    string email  = null;
..................................
db Conncetion; datareader; call stored proc;
..................................

ReaderEL = custTable_db.ExecuteReader(dbCommand);
//Loop through reader and add settlement details to arraylist
while (ReaderEL.Read())
{
    list_emails.Add(ReaderEL.GetValue(0).ToString());
    i = i + 1;
}

       MailMessage objMail = new MailMessage();
       SmtpClient mSmtpClient = new SmtpClient();

foreach (string email_to in list_emails)                      
       {
                                                                  
         objMail.From = new MailAddress("noreply@abc.com");
         objMail.To.Add(new MailAddress(email_to));
         objMail.Subject = txtSubject.Text.Trim();
         objMail.Body = ftbEmailMesg.Text;
         objMail.Priority = MailPriority.Normal;
         objMail.IsBodyHtml = true;
         mSmtpClient.Host = "00.000.0.000";
         mSmtpClient.Send(objMail);              
        }

Appreciate any help!

Posted 10-Oct-14 8:48am

Member 9901144

Add a Solution

2 solutions

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2014-10-10T09:41:00

Solution 1

What's would make the difference if you send just one message to a list of addresses? Only one: all the recipients would be aware of all other recipients.

So, I can assume this is the reason you might have for sending it "to every each user separately", to keep other users in secret. I cannot see other reasons.

If so, you have two options 1) put just one address to the "To:" header and other addressed to "BCC:" header, which makes the content of this list to be sent to each participant; 2) send a list of separate messages in a loop, changing only the "To:" header, with only one address on each iteration (there is no such thing as miracle :-)).

—SA

Posted 10-Oct-14 9:41am

Sergey Alexandrovich Kryukov

Updated 10-Oct-14 10:01am

v2

Comments

Afzaal Ahmad Zeeshan 10-Oct-14 16:01pm

I have editted your answer, 'the' had to be 'to'.

Sergey Alexandrovich Kryukov 10-Oct-14 16:14pm

Thank you very much, Afzaal.
—SA

Member 9901144 20-Oct-14 16:42pm

Thank you for your respond!!
Here's the fragment of the code for your suggested option 2:
objMail.From = new MailAddress("noreply@abc.com");
objMail.Subject = txtSubject.Text.Trim();
//objMail.Bcc.Add(bcc);
objMail.Body = ftbEmailMesg.Text;
objMail.Priority = MailPriority.Normal;
objMail.IsBodyHtml = true;

for (i = 0; i < list_Emails.Count; i++)
{
email = Convert.ToString(list_Emails[i]);
objMail.To.Add(email);
// objMail.Bcc.Add(email);
mSmtpClient.Host = "00.000.0.000";
mSmtpClient.Send(objMail);
}
When I used this loop to send a separate email to the user, unfortunately, all users email display in "To" property. Could be my loop is wrong?
Thanks Sergey!

Sergey Alexandrovich Kryukov 20-Oct-14 16:53pm

Where are all your addresses? You show only one...
—SA

Member 9901144 20-Oct-14 16:58pm

list_Email is my ArrayList which hold the list of emails from database(see my orig code)

Sergey Alexandrovich Kryukov 20-Oct-14 17:06pm

I see, thank you. Well, it is apparent what's going on. This is impossible nonsense. Here is what you do: send one e-mail with one address. Then add one more and send another e-mail with three addresses, then add, send more and more, the last one with full list.

Here is one solution: turn on your brain.

—SA

Sergey Alexandrovich Kryukov 20-Oct-14 16:51pm

Thank you Afzaal.
—SA

Afzaal Ahmad Zeeshan · Answer 2 · 2014-10-10T10:11:00

That is why you need to use the ASP.NET way of doing this, as already mentioned you can use a loop, to send it to all of the recipients, the only single message. For example

C#

foreach (var recipient in recipients) {
  // send the email
}

This is an example code which can be implemented as follows,

C#

// example array of recipients 
var recipients = {"array@example.com", "ofrecipients@example.com"};
// now loop through the recipients, 
foreach (var recipient in recipients) {
  // use the WebMail class, 
  WebMail.Send(to: recipient,
               subject: "Subject of the Email",
               body: "The message of the email."
               );
}

Once this ends, the emails would be send to the users, in the list or array that you will pass to the loop. In the loop, to field is a variable and depends on the value passed by the loop.

You can learn how to send emails using ASP.NET WebMail class from an article I wrote back a few months, Sending Emails Easily Using ASP.NET Helpers[^]

Alternate way

There is another way, of doing this, that is to attach a BCC (Blind Carbon Copy) to the email this would not reveal the recipient's information to other recipients, but will not be a good way, since you don't know how many email recipients you might have and so on. So using a loop and passing values of email address of the recipients will be a better bid for this.