Send email with excel attachment codes

Question

pls where can i find step by step code , to send email with attachements by creating excel files from a database table Thanks Chinedu Nwankwo

Rahul · Answer

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)); }

Send email with excel attachment codes

Answers (1)