Asp net send email with excel attachement

Introduction

ASP.NET is a popular programming language used for developing web applications. One common requirement in web applications is the ability to send emails with attachments. In this article, we will explore how to send an email with an Excel attachment using ASP.NET.

Prerequisites

Before we begin, make sure you have the following prerequisites:

• Visual Studio installed on your machine
• An SMTP server to send emails

Step 1: Setting up the ASP.NET Project

First, let's create a new ASP.NET project in Visual Studio. Open Visual Studio and go to File > New > Project. Select the ASP.NET Web Application template and give your project a name. Click OK to create the project.

Step 2: Adding the Required NuGet Packages

In order to send emails, we need to install the MailKit and MimeKit NuGet packages. Right-click on your project in the Solution Explorer and select Manage NuGet Packages. Search for MailKit and MimeKit and install both packages.

Step 3: Writing the Code

Now, let's write the code to send an email with an Excel attachment. Open the HomeController.cs file in your project and add the following code:

using MailKit.Net.Smtp;
using MimeKit;

public class HomeController : Controller
{
    public IActionResult SendEmailWithAttachment()
    {
        var message = new MimeMessage();
        message.From.Add(new MailboxAddress("Sender Name", "sender@example.com"));
        message.To.Add(new MailboxAddress("Recipient Name", "recipient@example.com"));
        message.Subject = "Email with Excel Attachment";

        var builder = new BodyBuilder();
        builder.TextBody = "Please find the attached Excel file.";

        var attachment = new MimePart("application/vnd.ms-excel")
        {
            Content = new MimeContent(File.OpenRead("path/to/excel/file")),
            ContentDisposition = new ContentDisposition(ContentDisposition.Attachment),
            ContentTransferEncoding = ContentEncoding.Base64,
            FileName = "example.xlsx"
        };

        builder.Attachments.Add(attachment);
        message.Body = builder.ToMessageBody();

        using (var client = new SmtpClient())
        {
            client.Connect("smtp.example.com", 587, false);
            client.Authenticate("username", "password");
            client.Send(message);
            client.Disconnect(true);
        }

        return View();
    }
}

In the above code, we first create a new instance of the MimeMessage class and set the sender, recipient, and subject of the email. We then create a BodyBuilder object and set the text body of the email. Next, we create a MimePart object for the Excel attachment and add it to the Attachments collection of the BodyBuilder. Finally, we send the email using the SmtpClient class.

Step 4: Testing the Email Sending

To test the email sending functionality, let's add a button to the view. Open the Index.cshtml file in the Views/Home folder and add the following code:

@{
    ViewBag.Title = "Home Page";
}

Welcome to ASP.NET!


    To send an email with an Excel attachment, click the button below:


Send Email

Now, when you run the application and click the “Send Email” button, it will send an email with the Excel attachment to the specified recipient.

Conclusion

In this article, we have learned how to send an email with an Excel attachment using ASP.NET. By following the steps outlined above, you can easily incorporate email sending functionality into your ASP.NET web applications.