Subscribe to Youtube channel

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

Post a Comment

Popular posts from this blog

Root your Gingerbread 2.3.4 android Mobile Phone

-
Root your Gingerbread 2.3.4 android Mobile Phone with following steps. before you start you have to download some files from here and follow the steps below  Put the phone in Debug Mode: Go to Settings > Applications > Development and check USB debugging box. Extract the files from the zip below, connect the phone via USB, and copy them to the phone via ADB like this: Code: adb push Superuser.apk /sdcard/Superuser.apk adb push su /sdcard/su adb push busybox /sdcard/busybox adb push exploit.bin /data/local/tmp/exploit.bin   Now we enter the phone's internal shell, also using ADB: Code: adb shell Then we take advantage of the "fake" root exploit: Code: cd /data/local/tmp chmod 0755 exploit.bin ./exploit.bin Now after that last command you should be back to your normal console, not the phone one, so we need to connect to it again, and doing so we should now see that we have root permissions since the "#" symbol is displayed
Read more

Implement Logging in CSV file using Nlog in .net core MVC application- part 2

-
Image
In previous article " Implement Nlog in .Net core MVC application part 1 "  I have demonstrated how we can implement basic setup of NLog in .core mvc application. In previous article we have logged the exceptions in flat file system. In this article I will show you how you can write the exception and custom logs in csv file. Writing logs in csv file can enable us better readability of logs in tabular form.       Lets start the implementation of it, I going to use the same example project used in previous demonstration. Modify the Nlog.config file as follows, added new target and rule for logging logs in csv file. <?xml version="1.0" encoding="utf-8" ?> <nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.nlog-project.org/schemas/NLog.xsd NLog.xsd" autoReload="true" throwExceptions="fal
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

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

Devexpress Datebox date formatting in angular 6 with example

-
The Devexpress DateBox in Angular is a widget that displays the date and time in one of DevExtreme predefined formats or a format defined in an external localization library, or a type in the required date/time value. In this article, the i will provide you different date-format which we can set on DateBox to show date and time to user. Following is the code snippet to add Datebox in your Angular form if the you want to capture only date      <dx-date-box [value]="now" displayFormat="EEEE, MMM dd" type="date" > </dx-date-box> Following is the custom formats we can set and depending upon its converted values will be shown. "dd-MM-yyyy" => 28-10-2018 "EEEE, MMM dd" => Sunday, Oct 28 "dd MMM yyyy EEEE" => 28 Oct 2018 Sunday "dd-MM-yyyy EEEE" => 28-10-2018 Sunday alternatively you can change the format as way you want Following is
Read more

Implement Nlog in .Net core MVC application part 1

-
Image
Logging is a very important part of the enterprise application/web application. Setting up the logging correctly not only beneficial for long term maintenance of the application but also it is useful tool to find out the RCA in case of mission critical bug arises. Therefor we will going to discuss the various logging technique implementation using Nlog library package. In this article we will going to use .net core application for demonstration but you can implement it in .net framework application also. So lets start the implementation of Nlog in .net core MVC application. Open visual studio 2019/17 and create the new project as shown below.     Select Asp.net core Web App (Model-View-Controller) and provide the project name in project name text box.   Now on next screen click on create button this will create MVC app with .net core Now go to solution explorer and right click on project and click on Manage Nuget Package. Now in Nuget package manager install below listed Nlog packages.
Read more

Angular User Session Timeout example step by step

-
Image
This functionality let the user know that their session is about to expire and that they would be logged out if they didn’t take action. I have written this functionality in Angular for my latest application.  If you are new to Angular 6 then read my article about Setting up Angular 6 step by step before jump to this article to get handy in Angular 6. Dealing with timers in Angular can be significantly different when using React components and subscriptions. The basic premises remains the same, though. We’ll have a service with a timer that will provide a Subject to which consumers of the service can subscribe. A React Subject provides an easy mechanism to trigger a “next” subscription to alert consumers that the timer has expired.   import { Injectable } from '@angular/core'; import { Observable, Subject, Subscription, BehaviorSubject} from 'rxjs/Rx'; @Injectable() export class IdleTimeoutService { private _count: number = 0;
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 file-upload 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
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