<%@ Page Language="C#" %>

<script runat="server">

    void Page_Load(Object Src, EventArgs E)

try

        System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();

        System.Net.NetworkCredential cred = new System.Net.NetworkCredential("someone@acme.com", "p@ssword");

        mail.To.Add("someone@somewhere.com");

        mail.Subject = "Invoice";

        mail.From = new System.Net.Mail.MailAddress("someone@acme.com");

        mail.IsBodyHtml = true;

        mail.Body = "Invoice is attached";

        //Get some binary data

        byte[] data = GetData();

        //save the data to a memory stream

        System.IO.MemoryStream ms = new System.IO.MemoryStream(data);

        //create the attachment from a stream. Be sure to name the data with a file and

        //media type that is respective of the data

        mail.Attachments.Add(new System.Net.Mail.Attachment (ms, "example.xls", "application/vnd.ms-excel"));

        System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient("smtp.acme.com");

        smtp.UseDefaultCredentials = false;

        //smtp.EnableSsl = true;

        smtp.Credentials = cred;

        smtp.Port = 587;

        smtp.Send(mail);

        Response.Write("Done!");

        catch(Exception ex)

            Response.Write(ex.ToString());

    static byte[] GetData()

        //this method just returns some binary data.

        //it could come from anywhere, such as Sql Server

        //string s = "this is some text";

        System.Data.DataTable workTable = new System.Data.DataTable();

        workTable.TableName = "Customers";

        workTable.Columns.Add("Id");

        workTable.Columns.Add("Name");

        System.Data.DataRow workRow;

        for (int i = 0; i <= 9; i++)

            workRow = workTable.NewRow();

            workRow[0] = i;

            workRow[1] = "CustName" + i.ToString();

            workTable.Rows.Add(workRow);

        string strBody = DataTable2ExcelString(workTable);

        byte[] data = Encoding.ASCII.GetBytes(strBody);

        return data;

    static string DataTable2ExcelString(System.Data.DataTable dt)

        StringBuilder sbTop = new StringBuilder();

        sbTop.Append("<html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" ");

        sbTop.Append("xmlns=\" http://www.w3.org/TR/REC-html40\"><head><meta http-equiv=Content-Type content=\"text/html; charset=windows-1252\">");

        sbTop.Append("<meta name=ProgId content=Excel.Sheet ><meta name=Generator content=\"Microsoft Excel 9\"><!--[if gte mso 9]>");

        sbTop.Append("<xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>" + dt.TableName + "</x:Name><x:WorksheetOptions>");

        sbTop.Append("<x:Selected/><x:ProtectContents>False</x:ProtectContents><x:ProtectObjects>False</x:ProtectObjects>");

        sbTop.Append("<x:ProtectScenarios>False</x:ProtectScenarios></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets>");

        sbTop.Append("<x:ProtectStructure>False</x:ProtectStructure><x:ProtectWindows>False</x:ProtectWindows></x:ExcelWorkbook></xml>");

        sbTop.Append("<![endif]-->");

        sbTop.Append("</head><body><table>");

        string bottom = "</table></body></html>";

        StringBuilder sb = new StringBuilder();

        //Header

        sb.Append("<tr>");

        for (int i = 0; i < dt.Columns.Count; i++)

            sb.Append("<td>" + dt.Columns[i].ColumnName + "</td>");

        sb.Append("</tr>");

        //Items

        for (int x = 0; x < dt.Rows.Count; x++)

            sb.Append("<tr>");

            for (int i = 0; i < dt.Columns.Count; i++)

                sb.Append("<td>" + dt.Rows[x][i] + "</td>");

            sb.Append("</tr>");

        string SSxml = sbTop.ToString() + sb.ToString() + bottom;

        return SSxml;

</script>