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