How to attach datagridview content to Outlook mail body

Mekalamani V

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Phadke10y ago
What error it is giving you can you provide the snippet
Mekalamani V10y ago
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 V10y ago
But this is not working properly
Mekalamani V10y ago
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("<" + "table border='1' cellpadding='10' cellspacing='0'>");
strTable.Append("
");
//Create Header Row for Table
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
strTable.AppendFormat("
", col.HeaderText);
}
strTable.Append("
");
//Create Table Rows
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
strTable.Append("
");
foreach (DataGridViewCell cell in dataGridView1.Rows[i].Cells)
{
if (cell.Value != null)
{
strTable.AppendFormat("
", cell.Value.ToString());
}
}
strTable.Append("
");
}
strTable.Append("
{0}
{0}
");
}
catch
{
}
return strTable.ToString();
}
Akshay Phadke10y ago
Your welcome i hope it worked for you :)
Mekalamani V10y ago
Thank You for Your Reply
This link for gmail. I want to send mail from Outlook
Akshay Phadke10y ago
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

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