Please Help - Send Emails to All Email Addresses in Datagrid

Question

Hi,
Just wanted put this out there to all the brainiacs because i just cant seem to do this.
I have a datagrid with columns
Date, DateNow, DateDifference, Email

They are all populated and i was wondering if when date difference hits 7 days it could send an email to everyone that has a date difference of 7 days or more.

I know how to send a single email but not how to go through the whole datagrid and do it.
Outlook.Application oApp = new Outlook.Application();
Outlook.MailItem email = (Outlook.MailItem)(oApp.CreateItem(Outlook.OlItemType.olMailItem));
email.Recipients.Add(textBox1.Text); //*need this for datagridview
email.Subject = "Reminder - 7 days difference;
email.Body = "7 Days Difference";
((Outlook.MailItem)email).Send();

Thanks alot for your patience and time.
Regards
Anthony

Shahan Ayyub · Answer

Oooops!!! Please check this code: I didn't handle the scenario for the EXTRA ROW of DataGridView: private void MailOnCheck_Click(object sender, EventArgs e) { for (int i=0;i { DataGridViewCellCollection cells = dataGridView1.Rows[i].Cells; if (int.Parse(cells[2].Value.ToString ()) >= 7) { //Your mailing stuff //Get the address directly from gridview i.e., cells[3] } } } Previous post still can be use for instructions.

Shahan Ayyub · Answer

Hi! I created a table having columns: Id ------------> Number DateNow ---------> DateTime DateDiff -------------> Number Email ------->Text Your checking button code: (PLEASE READ THE COMMENTS INSIDE BLOCK IT MIGHT HELP YOU MORE) private void MailOnCheck_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dataGridView1.Rows) { DataGridViewCellCollection cells = row.Cells; if (int.Parse(cells[2].Value.ToString ()) >= 7) { //Your mailing stuff //You can also get the address directly from gridview i.e., cells[3] for mailing //rather than getting it from textbox. } } }

Please Help - Send Emails to All Email Addresses in Datagrid

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)