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