public ActionResult ExportMailReportToExcel() { DateTime from; DateTime to; DateTime.TryParse(TempData["fromDTTM"].ToString(),out from); DateTime.TryParse(TempData["toDTTM"].ToString(),out to); from = from == DateTime.MinValue ? DateTime.Today : from; to = to == DateTime.MinValue ? DateTime.Today : to; List allUsers; var users = _profileService.GetMailSenderReportWithoutPage(from, to); allUsers = users.ToList(); Response.AddHeader("Content-Disposition", "filename=MailSent-" + TempData["fromDTTM"].ToString()+"-to-"+TempData["toDTTM"].ToString()+ ".xls"); Response.ContentType = "application/vnd.ms-excel"; Response.Write(""); Response.Write(""); Response.Write(""); Response.Write(""); Response.Write(""); Response.Write(""); Response.Write(""); Response.Write(""); foreach (var user in allUsers) { Response.Write(""); Response.Write(""); Response.Write(""); Response.Write(""); } Response.Write("

Recipient Name	E-Mail	Subject	Date
" + user.PersonName.ToString() + "	" + user.ToAddress.ToString() + "	" + user.Subject.ToString() + "	" + user.CWhen.ToString() + "

"); Response.End(); return View("MailSentReport"); }