private void OpenCSV_button_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "CSV files (*.csv)|*.csv|All files (*.*)|*.*";
if (openFileDialog1.ShowDialog() == true)
{
/*System.IO.StreamReader sr = new System.IO.StreamReader(openFileDialog1.FileName);
* string _wholecsvstring = await sr.ReadToEndAsync();
* sr.Close();
* MessageBox.Show(_wholecsvstring);
*/
CSV_dt = DataTable.New.ReadCsv(@openFileDialog1.FileName);
RecipientsList.Clear();
foreach (Row row in CSV_dt.Rows)
{
recipient newObject = new recipient
{
smtp = row.GetValueOrEmpty("recipientSMTPAddress"),
name = row.GetValueOrEmpty("recipientName"),
var1 = row.GetValueOrEmpty("var1"),
var2 = row.GetValueOrEmpty("var2"),
var3 = row.GetValueOrEmpty("var3"),
var4 = row.GetValueOrEmpty("var4"),
var5 = row.GetValueOrEmpty("var5")
};
RecipientsList.Add(newObject);
}
listBox.ItemsSource = RecipientsList;
label1.Content = "";
}
}
void SendEmail(ExchangeService service, recipient _recipient)
{
EmailMessage message = new EmailMessage(service);
message.Sender = new EmailAddress(ConfigurationSettings.AppSettings["EWSsendAsUser"]);
message.ToRecipients.Add(_recipient.smtp);
string _msgSubject = App.Current.Properties["MsgSubject"].ToString();
_msgSubject = _msgSubject.Replace("###recipientName###", _recipient.name);
_msgSubject = _msgSubject.Replace("###var1###", _recipient.var1);
_msgSubject = _msgSubject.Replace("###var2###", _recipient.var2);
_msgSubject = _msgSubject.Replace("###var3###", _recipient.var3);
_msgSubject = _msgSubject.Replace("###var4###", _recipient.var4);
_msgSubject = _msgSubject.Replace("###var5###", _recipient.var5);
message.Subject = _msgSubject;
string _msgBody = App.Current.Properties["MsgBody"].ToString();
_msgBody = _msgBody.Replace("###recipientName###", _recipient.name);
_msgBody = _msgBody.Replace("###var1###", _recipient.var1);
_msgBody = _msgBody.Replace("###var2###", _recipient.var2);
_msgBody = _msgBody.Replace("###var3###", _recipient.var3);
_msgBody = _msgBody.Replace("###var4###", _recipient.var4);
_msgBody = _msgBody.Replace("###var5###", _recipient.var5);
_msgBody = _msgBody.Replace(Environment.NewLine, "<br />");
message.Body = @"<meta http-equiv='Content-Type' content='text/html; charset=us-ascii'>";
message.Body += "<span style='font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 11pt;'>";
message.Body += _msgBody;
message.Body += "</span>";
message.Body.BodyType = BodyType.HTML;
if (ConfigurationSettings.AppSettings["SaveCopyInSentItems"] == "yes")
{
message.SendAndSaveCopy();
}
else
{
message.Send();
}
}