Send email to multiple email addresses retrieved from database?

Question

0.00/5 (No votes)

See more:

So my problem is that I need to select multiple email addresses from the database and then send them an email.
Is it possible to do that?
So basically I need to string sql to find the email addresses that I need and then use DBUTL.SendEmail to send these email addresses an email. How do I do it?

What I have tried:

// string sqlB = @"SELECT email, attendees_email
              FROM Staff S INNER JOIN Staff_have_meetings SHM ON S.staff_id = SHM.staff_id
              INNER JOIN Meeting M ON M.meeting_id = SHM.meeting_id
              INNER JOIN Attendees A on A.attendees_id = AHM.attendees_id
              AND AHM.meeting_id ={0}";
 DataTable ds = DBUtl.GetTable(sqlB, TxtMeetingID);

 string template = EMAIL MESSAGE (Which I have done too);
 string title = "Cancellation of a meeting";
 string link = "http://SendNotification.aspx";
 string message = String.Format(template, link);
 string result;
 if (EmailUtl.SendEmail(sqlB, title, message, out result))
 {
     LtlMsg.Text = "Cancellation Email has been sent.";
 }

 else
 {
     LtlMsg.Text = "Error " + DBUtl.DB_Message;
 }

I would keep getting error saying it is not in the form of an email address.
what do I have to do with the query, so that i can retrieve the email and send email to the selected email addresses?

Posted 24-Jan-18 22:23pm

dibdab

Updated 26-Jun-18 11:20am

v2

Add a Solution

Comments

F-ES Sitecore 25-Jan-18 4:42am

You'll probably need to loop through the dataset and send an individual email to each person

string html = "my email"
foreach (record in results)
{
Sendemail to record["recipient address"]
}

You haven't provided enough code to give a specific example of what you need to do.

dibdab 25-Jan-18 6:18am

I am not very sure how to code it yet.. but basically I need to retrieve the value from the database with the query.. and then combine them with ";" and send them an email..

F-ES Sitecore 25-Jan-18 6:20am

That's generally considered a bad idea as it reveals the email addresses of other people to the list. The standard behaviour is to send each person an individual email.

dibdab 25-Jan-18 6:23am

It should be fine because its just within my team..

A_Griffin 25-Jan-18 4:54am

Have you checked that all the email addresses in the database are valid? Your error message would suggest that maybe some are not (or maybe are just empty strings).
Also, if/when you do get this working, bear in mind that many if not most ISP's provide strict limits on how many emails you can send within certain time periods. You may need to use an email relay service if sending to lots of addresses.

dibdab 25-Jan-18 6:20am

Yea.. they are all valid..
No worries I only have to send it to a few people.
I tried to google an example for this but I can't seem to find one that I can string their email with ";" and then send all the contact an email.

dibdab 25-Jan-18 9:49am

Thank you for the solution @F-ES Sitecore

2 solutions

Solution 2

You can do this by using Carbon Copy ability. See code, below.

MailMessage mail_IS = new MailMessage("from email address", "TO email address");
mail_IS.IsBodyHtml = true;

mail_IS.CC.Add(new MailAddress("hello@world.org"));

Posted 26-Jun-18 11:21am

Lay_Kay

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)

F-ES Sitecore · Accepted Answer · 2018-01-25T00:54:00

// I'm hard-coding the DataTable for the example
// you'll use the DataTable you have and the right column name
// for the email field
DataTable ds = new DataTable();
ds.Columns.Add("Email", typeof(string));
ds.Rows.Add("email1@domain.com");
ds.Rows.Add("email2@domain.com");
ds.Rows.Add("email3@domain.com");

string emailList = ds.Select()
    .Select(r => (string)r["Email"])
    .Aggregate((a, b) => a = a + ";" + b);

in the above emailList will now contain a list of all email addresses separated by semi-colons.