private void SendMailtoForwaredUser() { string strFromEmail = ""; string strToEmail = ""; string strCCEmail = ""; List <string> strToEmails = new List <string>(); List <string> strCCEmails = new List <string>(); DataTable dtInquriyDetails = new DatabaseService().executeSelectQuery("SELECT * FROM Inquiry WHERE InquiryNumber = '" + lblInqNo.Text.ToString() + "'"); DataTable dtCusDetais = new DatabaseService().executeSelectQuery("SELECT * FROM Customer WHERE Id = '" + GetCusId(lblInqCus.Text.Trim()) + "'"); strFromEmail = GetEmail(GetEmpId(Views.frmHome.EmpName)); strToEmail = GetEmail(GetEmpId(lblInqForTo.Text.Trim())); strCCEmail = GetEmail(GetEmpId(lblInqForBy.Text.Trim())); StringBuilder strBuliderEmailSubject = new StringBuilder(); strBuliderEmailSubject.Append("Inquiry Forward Approved – Customer :" + lblInqCus.Text.Trim() + " " + " -Inquiry No :" + lblInqNo.Text.Trim() + " "); StringBuilder strBuliderEmailBody = new StringBuilder(); strBuliderEmailBody.Append("<head>"); strBuliderEmailBody.Append("<title>"); strBuliderEmailBody.Append(Guid.NewGuid().ToString()); strBuliderEmailBody.Append("</title>"); strBuliderEmailBody.Append("</head>"); strBuliderEmailBody.Append("<body>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("Dear " + lblInqForTo.Text.Trim() + ","); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("Inquiry <b><u><FONT COLOR=DodgerBlue>Forwarded</FONT></u></b>, pending for your Acceptance,"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Inquiry No : </b>" + lblInqNo.Text.Trim() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Type : </b>" + lblInqType.Text.Trim() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Customer : </b>" + lblInqCus.Text.Trim() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Location : </b>" + GetSubLocationName(dtInquriyDetails.Rows[0]["Location"].ToString()) + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Caller Name : </b>" + dtInquriyDetails.Rows[0]["CallerName"].ToString() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Caller Phone : </b>" + dtInquriyDetails.Rows[0]["CallerPhone"].ToString() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Inquiry Details : </b>" + dtInquriyDetails.Rows[0]["FollowupDetails"].ToString() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Priority : </b>" + dtInquriyDetails.Rows[0]["Priority"].ToString() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Job Entry Date & Time : </b>" + Convert.ToDateTime(dtInquriyDetails.Rows[0]["JobEntryDate"].ToString()).ToString("mm/dd/yyyy") + " " + dtInquriyDetails.Rows[0]["JobEntryTime"].ToString() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Forwarded By : </b>" + lblInqForBy.Text.Trim() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Remarks : </b>" + lblInqRemarks.Text.Trim() + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Forward Approved By : </b>" + Views.frmHome.EmpName + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append(" <b>Forward Approved Date & Time : </b>" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("Regards,"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("" + Views.frmHome.EmpName + ""); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("<FONT COLOR=darkred>Auto generated email from CRM system</FONT>"); strBuliderEmailBody.Append("<br>"); strBuliderEmailBody.Append("</body>"); strBuliderEmailBody.Append("</html>"); EmailServices Email = new EmailServices(); Email.SendEmailsCC(strFromEmail.Trim(), strToEmail.Trim(), strCCEmail.Trim(), strBuliderEmailSubject.ToString(), strBuliderEmailBody.ToString()); }