How to attach datagridview content to Outlook mail body

Question

Hi frds, I have 10 columns in my datagridview but I run time it will show only 6 columns. I want to send this 6 columns to mail body.how can i do this. Any One help. Its Urgent.

Akshay Phadke · Answer

What error it is giving you can you provide the snippet

Mekalamani V · Answer

Date Customer Order No Qty Amount 23-06-2016 AAA 1 200 1000 23-06-2016 BBB 2 100 600 Total 300 1600 22-06-2016 CCC 3 50 300 22-06-2016 DDD 4 20 100 Total 70 400 370 2000 My Datagridview is in this format. I want to attach this to outlook how can i do this. Reply me as soon as possible.

Mekalamani V · Answer

But this is not working properly

Mekalamani V · Answer

My code is here try { outlook._Application _app = new outlook.Application(); outlook.MailItem mail = (outlook.MailItem)_app.CreateItem(outlook.OlItemType.olMailItem); mail.To = textBox6.Text; mail.CC = textBox2.Text; mail.BCC = textBox3.Text; mail.Subject = textBox4.Text; mail.Body = textBox5.Text; mail.BodyFormat = outlook.OlBodyFormat.olFormatHTML; mail.HTMLBody = GetTableFromDataGrid(); mail.Importance = outlook.OlImportance.olImportanceNormal; ((outlook._MailItem)mail).Send(); MessageBox.Show("Mail has been sent successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } public string GetTableFromDataGrid() { StringBuilder strTable = new StringBuilder(); try { //strTable.Append(" ");:Solid 1px Black strTable.Append(" "); strTable.Append(" "); //Create Header Row for Table foreach (DataGridViewColumn col in dataGridView1.Columns) { strTable.AppendFormat(" {0} ", col.HeaderText); } strTable.Append(" "); //Create Table Rows for (int i = 0; i { strTable.Append(" "); foreach (DataGridViewCell cell in dataGridView1.Rows[i].Cells) { if (cell.Value != null) { strTable.AppendFormat(" {0} ", cell.Value.ToString()); } } strTable.Append(" "); } strTable.Append(" "); } catch { } return strTable.ToString(); }

Akshay Phadke · Answer

Your welcome i hope it worked for you :)

Mekalamani V · Answer

Thank You for Your Reply This link for gmail. I want to send mail from Outlook

Akshay Phadke · Answer

Set autogeneratedcolumns property before assigning itemsource of your gridview so that you will see only 6 columns on runtime . For attachement of your mail refer this link http://stackoverflow.com/questions/2825950/sending-email-with-attachments-from-c-attachments-arrive-as-part-1-2-in-thunde

How to attach datagridview content to Outlook mail body

Answers (7)