How can I send generic list<T> in the body of outlook mail

Raushan Raj

I am using C# for my problem.
I have an Excel file which has many worksheets. From "Fisrt Sheet", I am looking for a character "x" which will be present in some cells of a specific column (occurence of "x" will be in one specific column only, in different cells of that column). I am looking for "x" and extracting the corresponding row's details in a generic list (with naming the headers of extracted field). Now, I have to send this generic list in "tabular format" in body of the mail via Outlook.
I am stuck with sending of list in tabular format in the mail body.

Please help me with my problem

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Data;
using Excel = Microsoft.Office.Interop.Excel;
using Outlook = Microsoft.Office.Interop.Outlook;
namespace xlsm
{
class New
{
static void Main(sting[] args)
{
sting st;
long rCnt, cCnt;
long rows = 0, columns = 0;
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range rng;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"F:\Doc_Excel", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets["First Sheet"];
rng = xlWorkSheet.UsedRange;
rows = rng.Rows.Count;
columns = rng.Columns.Count;
List lst = new List();
for (rCnt = 1; rCnt < rows; rCnt++)
{
for (cCnt = 1; cCnt < columns; cCnt++)
{
if ((rng.Cells[rCnt, cCnt] as Excel.rng).Value2 != null)
{
st = (rng.Cells[rCnt, cCnt] as Excel.rng).Value2.Tosting();
if (st == "x")
{
Memo ms = new Memo();
ms.MemoName = (rng.Cells[rCnt, 1] as Excel.rng).Value2.Tosting();
ms.Type = (rng.Cells[rCnt, 2] as Excel.rng).Value2.Tosting();
ms.Ext = (rng.Cells[rCnt, 3] as Excel.rng).Value2.Tosting();
ms.Seller = (rng.Cells[rCnt, 4] as Excel.rng).Value2.Tosting();
ms.Warehouse = (rng.Cells[rCnt, 5] as Excel.rng).Value2.Tosting();
lst.Add(ms);
}
}
}
}
try
{
Outlook.Application oApp = new Outlook.Application();
Outlook.MailItem oMsg = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem);
oMsg.HTMLBody = "";
oMsg.Subject = "Memo contents as required.";
Outlook.Recipients oRecims = (Outlook.Recipients)oMsg.Recipients;
Outlook.Recipient oRecip = (Outlook.Recipient)oRecims.Add("[email protected]");
oRecip.Resolve();
oMsg.Send();
oRecip = null;
oRecims = null;
oMsg = null;
oApp = null;
}
catch (Exception ex)
{
}
xlWorkBook.close(true, null, null);
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
}
}
public class Memo
{
public string MemoName { get; set; }
public string Type { get; set; }
public string Ext { get; set; }
public string Seller { get; set; }
public string Warehouse { get; set; }
}

7 Replies

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

Bikesh Srivastava9y ago
Just take value in generic field and pass to excel
0
Raushan Raj9y ago
@mahdi
Did you read my entire code?
I have already generated a List. I need not do it again. I just want to send my generated list
0
mahdi gh9y ago
Make a static class HtmlHelper and add this code to it:
public static string ToHtmlTable(this List listOfClassObjects)
    {
        var ret = string.Empty;

        return listOfClassObjects == null || !listOfClassObjects.Any()
            ? ret
            : "" +
              listOfClassObjects.First().GetType().GetProperties().Select(p => p.Name).ToList().ToColumnHeaders() +
              listOfClassObjects.Aggregate(ret, (current, t) => current + t.ToHtmlTableRow()) +
              "
";
    }

    public static string ToColumnHeaders(this List listOfProperties)
    {
        var ret = string.Empty;

        return listOfProperties == null || !listOfProperties.Any()
            ? ret
            : "" +
              listOfProperties.Aggregate(ret,
                  (current, propValue) =>
                      current +
                      ("" +
                       (Convert.ToString(propValue).Length <= 100
                           ? Convert.ToString(propValue)
                           : Convert.ToString(propValue).Substring(0, 100)) + "..." + "")) +
              "";
    }

    public static string ToHtmlTableRow(this T classObject)
    {
        var ret = string.Empty;

        return classObject == null
            ? ret
            : "" +
              classObject.GetType()
                  .GetProperties()
                  .Aggregate(ret,
                      (current, prop) =>
                          current + ("" +
                                     (Convert.ToString(prop.GetValue(classObject, null)).Length <= 100
                                         ? Convert.ToString(prop.GetValue(classObject, null))
                                         : Convert.ToString(prop.GetValue(classObject, null)).Substring(0, 100) +
                                           "...") +
                                     "")) + "";
    }
Then in your code pass it like this:
oMsg.HTMLBody = "
Report title
";
oMsg.HTMLBody += HtmlHelper.ToHtmlTable(lst);
0
Raushan Raj9y ago
How do I pass it in body ??
0
mahdi gh9y ago
If by tabular format you mean this in an HTML form:
MemoName Type Ext Seller Warehouse
dummy data dummy data dummy data dummy data dummy data
dummy data dummy data dummy data dummy data dummy data

refer to the link I told you. Otherwise please explain what tabular format is?
0
Raushan Raj9y ago
But I have data in List. I need to store my data in tabular format. I want solution for this!
0
mahdi gh9y ago
You can convert the data into html string and add it to your message body.
here you can find a way to convert it to html:

http://stackoverflow.com/a/24213841/1656260
0

MemoName	Type	Ext	Seller	Warehouse
dummy data	dummy data	dummy data	dummy data	dummy data
dummy data	dummy data	dummy data	dummy data	dummy data

How can I send generic list<T> in the body of outlook mail

Report title