Send email with excel attachment codes

Sign in to answer this question.

• R

  Rahul12y agoPosted Nov 3, 2014, 6:25 AM

  try

              {

  
  

                  MailMessage message = new MailMessage();

                  string s3 = string.Empty;

                  string tolist = ConfigurationManager.AppSettings["ToList"].ToString();

                  message.To.Add(tolist);

                  message.Subject = "Employee Attendence Email: " + DateTime.Now.Date.ToShortDateString();

                  message.IsBodyHtml = true;

  
  

                  //get the html body for email

                  //get template

                  StringBuilder emailBodyBuilder = new StringBuilder();

                  string path = ConfigurationManager.AppSettings["mailTemplate"];

                  StreamReader streamReader = new StreamReader(path);

                  string BODY = streamReader.ReadToEnd();

                  streamReader.Close();

                  message.Body = BODY;

  
  

                  string excelFileName = ConfigurationManager.AppSettings["DownloadPath"].ToString() + "Attendance Report" + DateTime.Now.ToString("MM_dd_yy") + ".xls";

  
  

                  //create excel file for modified deleted and new assignment.

                  if (File.Exists(excelFileName))

                  {

                      message.Attachments.Add(new Attachment(excelFileName));

                  }

                  MailAddress from = new MailAddress(ConfigurationManager.AppSettings["fromEmailAddress"]);

                  message.From = from;

                  SmtpClient smtpClient = new SmtpClient();

                  smtpClient.Host = "10.222.1.123";

                  smtpClient.Port = 25;

                  smtpClient.Send(message);

                  Misc.Log(DateTime.Now.ToString() + ": Mail sent Successfully");

              }

              catch (Exception e)

              {

                  Misc.Log(e.Message);

              }
  
  
  
  
  1.Create a method and place this code
  2. Make the change like subject and smtp ip and port, mail template
  3. else just replace the below code in your exiting code: 
  MailMessage message = new MailMessage();

                  if (File.Exists(excelFileName))

                  {

                      message.Attachments.Add(new Attachment(excelFileName));

                  }