Send bulk Email in asp.net using excel file

-
When you want to send the mail to multiple person email id and your data exists in the excel file like email address and his name. you can accomplish this task using asp.net and c#. In C# under System.Net.Mail and System.Net namespace you can use classes which can help us to send mail effortlessly.

I am giving some sample code to understand the concept

Following is aspx design Page Sample


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LogDatails.aspx.cs" Inherits="LogDatails" %> 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 

<html xmlns="http://www.w3.org/1999/xhtml" > 
<head runat="server"> 
    <title>Untitled Page</title> 
</head> 
<body> 
    <form id="form1" runat="server"> 
    <div> 
    <a href="Default.aspx">Back</a> 
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True"  PageSize="6" AutoGenerateColumns="False" CellPadding="4" DataSourceID="XmlDataSource1" ForeColor="#333333" GridLines="None"> 
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> 
            <Columns> 
                <asp:BoundField DataField="Message" HeaderText="Message" SortExpression="Message" /> 
                <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" /> 
            </Columns> 
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> 
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> 
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> 
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> 
            <EditRowStyle BackColor="#999999" /> 
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> 
        </asp:GridView> 
        <asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/myLog.xml"></asp:XmlDataSource> 
    </div> 
    </form> 
</body> 
</html>


and the following is aspx.cs Page sample



using System; 
using System.Data; 
using System.Configuration; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Web.UI.HtmlControls; 
using System.Net.Mail; 
using System.Net; 
using System.Data.OleDb; 
using System.Xml; 
using System.IO; 
public partial class _Default : System.Web.UI.Page
{ 
    XmlTextWriter writer; 
    protected void Page_Load(object sender, EventArgs e)
    { 

    } 
    protected void btnSend_Click(object sender, EventArgs e)
    {  
        SmtpClient client = new SmtpClient("smtp.gmail.com");//Host Name 
        MailMessage msg = new MailMessage(); 
        NetworkCredential account = new NetworkCredential("something@gmail.com", ""); //User Name Password of Ur Email  

        bool fileExist = false;


        MailAddress from = new MailAddress("something@gmail.com", "something"); //From Name 



        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.oledb.4.0;Data Source=" + Server.MapPath("~/Email.xls") + ";Extended Properties=Excel 8.0"); 
        string temp = OleDbMetaDataCollectionNames.Tables; 
        con.Open(); 
        DataTable dtsheetNames = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null); 
        con.Close(); 
        OleDbDataAdapter Sda = new OleDbDataAdapter("Select * from ["+dtsheetNames.Rows[0]["TABLE_NAME"]+"]",con); 
        DataTable dt=new DataTable("hello"); 
         
        Sda.Fill(dt); 
         
        lblStatus.Text = dt.Rows[0]["Name"].ToString(); 

        if (File.Exists(Server.MapPath(".") + "/myLog.xml") == true) 
        { 
            fileExist = true; 
         
        } 
        if (fileExist != true)
        { 
            createXml("", "", Server.MapPath(".") + "/myLog.xml", false, false);
        } 
        foreach (DataRow dr in dt.Rows)
        { 
             
          
            msg.From = from; 
              
            msg.To.Add(dr["Email"].ToString()); 
            msg.Body = txtBody.Text; 
            msg.IsBodyHtml = true; 
            msg.Subject = txtSubject.Text; 
            client.EnableSsl = true; 
            client.UseDefaultCredentials = false; 
            client.Credentials = account; 
            try 
            { 
                client.Send(msg); 
                lblStatus.Text =  lblStatus.Text+"Successully Sent Mail To \"" + dr["Name"].ToString() + "\" for the Email Id \"" + dr["Email"].ToString() + "\" <br>"; 
                if (fileExist != true)
                    createXml("Successully Sent Mail To \"" + dr["Name"].ToString() + "\" for the Email Id \"" + dr["Email"].ToString() + "\"", DateTime.Now.ToString("dd-MMM-yyyy hh:mm"), Server.MapPath(".") + "/myLog.xml", true, false); 
                else 
                    getxml("Successully Sent Mail To \"" + dr["Name"].ToString() + "\" for the Email Id \"" + dr["Email"].ToString() + "\"", DateTime.Now.ToString("dd-MMM-yyyy hh:mm"), Server.MapPath(".") + "/myLog.xml"); 
                  
            } 
            catch (Exception ex) 
            { 
                lblStatus.Text = lblStatus.Text + "Error sending Mail To \"" + dr["Name"].ToString() + "\" for the Email Id \"" + dr["Email"].ToString() + "\"<br>"; 

                if (fileExist != true)
                    createXml("Error sending Mail To \"" + dr["Name"].ToString() + "\" for the Email Id \"" + dr["Email"].ToString() + "\"", DateTime.Now.ToString("dd-MMM-yyyy hh:mm"), Server.MapPath(".") + "/myLog.xml", true, false); 
                else 
                    getxml("Error sending Mail To \"" + dr["Name"].ToString() + "\" for the Email Id \"" + dr["Email"].ToString() + "\"", DateTime.Now.ToString("dd-MMM-yyyy hh:mm"), Server.MapPath(".") + "/myLog.xml"); 
            
            } 
          
        } 
        if(!fileExist) 
        createXml("", "", Server.MapPath(".") + "/myLog.xml", false, true); 
    } 
    public void getxml(string message,string date,string fileName) 
    { 
        XmlDocument doc = new XmlDocument(); 
        doc.Load(fileName); 
        XmlElement el = doc.CreateElement("LogTable"); 
        el.SetAttribute("Message",message); 

        el.SetAttribute("Date", date); ; 
         
        doc.DocumentElement.AppendChild(el); 
        doc.Save(fileName); 
    } 
    public void createXml(string message, string date, string fileName, bool ischild, bool isendEle)
    { 
        if (ischild == false && isendEle==false) 
        { 
            writer = new XmlTextWriter(Server.MapPath(".") + "/myLog.xml", null); 

            writer.WriteStartDocument(); 
            writer.WriteStartElement("EmailLog"); 
        } 
        else 
        { 
            if (isendEle == false)
            { 
                writer.WriteStartElement("LogTable"); 
                writer.WriteAttributeString("Message", message); 
          


            writer.WriteAttributeString("Date", date); 
            writer.WriteEndElement();   } 
        } 
        if (isendEle == true)
        { 
            writer.WriteEndElement(); 
            writer.Close(); 
        } 
    } 
}

The above code reads the excel file and iterates each email id. This code also stores the logs of each mail sent into xml file for the reference. this code is ideal for the sending bulk emails using code. above code can be used as class library in project to reuse in different modules of project.

I Hope that you will benefited by the above code.

Hoppy Coding:)

Comments

  1. UnknownJune 6, 2012 at 2:42 AM

    its very nice that i stumbled upon your website..it was really a wonderful read...i will bookmark your website and will take the rss feed also...thanks for sharing...

    bulk email server

    ReplyDelete
  2. Vinay SinghDecember 11, 2012 at 3:24 AM

    If you need to build up a distribution lists you can get third parties to send on your behalf (the recipients of these e-mails have either signed up for this service or are content to see appropriate adverts within their mail).


    Best Email Marketing Software

    ReplyDelete
  3. klotyldaMarch 31, 2018 at 2:20 AM

    Awesome. I always make sure I'm building high quality lists by removing the invalid addresses as soon as I can. Luckily, thanks to my favourite mass email checker, correct.email, it's really just a piece of cake.

    ReplyDelete

Post a Comment

Popular posts from this blog

Restore the lost focus of Auto post back controls in asp.net update Panel control

-
Problem: We put  autopostback controls like textbox, DropDownList controls inside in update panel to reducing the flickering of the Page.but when user uses tab for entering the details  the focus of the control losts. Web site users who prefer to use keyboard need to use mouse to activate appropriate input box or press TAB multiple times. Solution: Step 1: Save following in js file give any name to it (like MyUpdatePanelFocus.js ) var lastFocusedControlId = ""; function focusHandler(e) { document.activeElement = e.originalTarget; } function appInit() { if (typeof (window.addEventListener) !== "undefined") { window.addEventListener("focus", focusHandler, true); } Sys.WebForms.PageRequestManager.getInstance().add_pageLoading(pageLoadingHandler); Sys.WebForms.PageRequestManager.getInstance().add_pageLoaded(pageLoadedHandler); } function pageLoadingHandler(sender, args) { lastFocusedControlId = typeof (document.acti
Read more

Clone a generic list in C# using extension method

-
In practical situation you need to clone of object so that change in cloned object will not affect the original one. If you need a cloned list with the same capacity you need to do some extra stuff with your user type. I came up with this easy solution using ICloneable interface in your custom type class. The first step you need to implement the ICloneable interface in your class like below. public class MyClassDto : ICloneable { public Int64 Id { get; set; } public string Time { get; set; } public int user{ get; set; } public object Clone() { return new MyClassDto{ Date = this.Date, Id = this.Id, user = this.user}; } } after that you need to add extension method in common class so that you can use it everywhere you want. public static class Extensions { public static List<T> Clone<T>(this List<T> listToClone) where T : ICloneable { return listToClone.Select(item
Read more

Disable backspace key using Jquery

-
Disable backspace key in HTML form using Jquery in simple steps. While user enters data into application if user accidentally  press backspace button then it will redirect to previous page and all entered data would be lost. to eliminate this event we can disable the backspace key using Jquery. Following is the JQuery script tag you can add to the web page $(document).keydown(function (e) { var nodeName = e.target.nodeName.toLowerCase(); if (e.which === 8) { if ((nodeName === 'input' && e.target.type === 'text') || nodeName === 'textarea') { // do nothing } else { e.preventDefault(); } } }); The above code can be used seamlessly with any web technology you are using. Hope this will help you in your web application. Happy coding:)
Read more

Add Comma automatically while entering amounts in textbox using Javascript

-
Use following javascript function to add comma in numerics input in textbox function Comma(Num) { Num += ''; Num = Num.replace(/,/g, ''); x = Num.split('.'); x1 = x[0]; x2 = x.length > 1 ? '.' + x[1] : ''; var rgx = /(\d)((\d)(\d{2}?)+)$/; while (rgx.test(x1)) x1 = x1.replace(rgx, '$1' + ',' + '$2'); return x1 + x2; } Use following event of input textbox to call above function onkeyup = "javascript:this.value=Comma(this.value);"
Read more

Step by step migration of ASP.NET Core 2.2 to 3.1

-
In order to upgrade/migrate asp.net core version to 3.1 following steps to be perform. Download and install Visual Studio 2019 version 16.4 or higher. Download and install .NET Core 3.1  https://dotnet.microsoft.com/download/dotnet-core/3.1 Upgrade the projects of solution to .NET Core 3.1 , because ASP.NET Core 3.1 requires it. Update existing Nuget packages to a version compatible with ASP.NET Core 3.1 in each project Use IHost interface from a IHostBuilder instead of building and running a IWebHost from a IWebHostBuilder in Program.cs public static IHostBuilder CreateWebHostBuilder(string[] args) => Host.CreateDefaultBuilder(args) .ConfigureWebHostDefaults(webBuilder => { webBuilder.UseKestrel() .UseSerilog() .UseStartup<Startup>(); }) Change AddMvc method has been replaced by AddControllers in Startup.cs of each projects. In Startup.cs, UseMvc method to b
Read more

Source Code Beautifier And Format Source Code For Blogger and Websites

-
Source Code Beautifier And Formatter For Blogger and Websites, Format Source Code , Format Source code for blog or blogging & website, Online line source code formatter tool, blogger code format tool, Format source code for blog-spot,Insert formatted source code How to format source code for blogger & website :   You can format your source code for blogger & website in easy three steps.. 1) Paste your source code into "Paste Here Your Source Code" Text-area. 2) Choose appropriate options from "formatting options" and click Format Source Code button.. 3) See preview of formatted source code if it's fine then copy from "Copy Formatted Source Code" text-area otherwise repeat step 2  This source code formatter allow you to format code like JavaScript, HTML, CSS, C#, PHP, ASP.net, VB.Net, Visual Basic, DOT.net, ASP & many other languages.  It does not add unnecessary tags into formatted code, It use only two t
Read more

Remove Owin from MVC 5 Application and use asp.net custom forms authentication

-
Image
Owin comes with 15 other dependencies when we add default "blank" mvc5 template in solution. Which some time is irrelevant to web application hence needs to be removed for adding custom authentication techniques in the web application. Remove the owin  from solution is tedious task but if we follow the below procedure then it can be easily removed from the solution. Right click on your project and from menu click on Manage Nuget Packages. on left side of Manage Nuget Packages window click on Installed Package then on right side of window in search box type owin.  Uninstall packages in order of: microsoft.aspnet.identity.owin microsoft.owin.host.systemweb microsoft.owin.security.cookies microsoft.owin.security.facebook microsoft.owin.security.google microsoft.owin.security.microsoftaccount microsoft.owin.security.twitter microsoft.aspnet.identity.entityframework microsoft.aspnet.identity.core Open web.config file and remove these sections from   &l
Read more

How to Import CSV File and bind csv file data to gridview in asp.net using c#

-
I am going to demonstrate in this article about importing CSV file data into datatable and then bind that data to Asp.net gridview control. i have tried to make code simpler and less line of code. I am assuming that you have saved the csv file to server by using fileupload control. After that create function which returns string[] private IEnumerable<string[]> GetAllDataFromCSVFile(string FileName) { string str; using (StreamReader rd=new StreamReader(FileName)) { while ((str = rd.ReadLine()) != null) { yield return str.Split(','); } } } Create another function which returns final data-table with CSV File data private DataTable GetCSVData(string FileName) { var values = GetAllDataFromCSVFile(FileName); DataTable dt = new DataTable(); int j=0; foreach (var i
Read more

Email validation using regular expression in jQuery

-
To validate user input for email-id it's very easy using regular expressions. Using regular expressions you do not need to write lengthy logical code in jQuery. Following are the steps to do the same. Pass a string to RegExp or create a regex using the  // syntax Call  regex.test(string) So code would be... jQuery ( function () { $ ( ".mail" ). keyup ( function () { var VAL = this . value ; var email = new RegExp ( '^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$' ); if ( email . test ( VAL )) { alert ( 'Great, you entered an valid E-Mail-address' ); } }); });
Read more