private void sendEmail(EmailObject eml) { string myDate = today.ToString("dd MMMM yyyy"); //new outlook instance Outlook.Application app = new Outlook.Application(); Outlook.MailItem mail = app.CreateItem(Outlook.OlItemType.olMailItem); { string[] files = Directory.GetFiles(AttachmentDestination); int fileCount = 0; foreach (string file in files) { Console.WriteLine("attatching file : " + file); mail.Attachments.Add(file); fileCount++; } if (fileCount > 0) { mail.Importance = Outlook.OlImportance.olImportanceHigh; mail.Subject = myDate + " " + eml.EmailSubject; mail.To = eml.Emails; mail.Body = eml.EmailBody; Console.WriteLine("sending..."); mail.Send(); } } }
public GenerateEmail(EmailObject emlObj) { // TODO: Complete member initialization this.sqlString = emlObj.Queries; this.users = emlObj.Emails; this.excelFolder = ConfigurationManager.ConnectionStrings["wbLoc"].ConnectionString; CreateSpreadsheets(); var emlSend = new SendEmail(emlObj, excelFolder); }
public SendEmail(EmailObject eml, string DownloadDestination) { AttachmentDestination = DownloadDestination; today = DateTime.Today; sendEmail(eml); }
private void readTable(DataTable dt) { for (int i = 0; i < dt.Rows.Count; i++) { //convert object array to string array with linq expression string[] emailData = ((IEnumerable)dt.Rows[i].ItemArray).Cast<object>() .Select(x => x.ToString()).ToArray(); var emlObj = new EmailObject(emailData); var gen = new GenerateEmail(emlObj); } }