Send Mis Report on mail

Hi,

I belive you would be able to access fetch data with the current given permission.

You can create a windows service which you can schedule to run daily.

Use the System.Web.Mail here is a sample.

MailMessage msgMail = new MailMessage();

msgMail.To = "[email protected]";
msgMail.Cc = "[email protected]";
msgMail.From = "[email protected]";
msgMail.Subject = "Hi Chris, another mail";

msgMail.BodyFormat = MailFormat.Html;
string strBody = "Hello World" +
   " ASP.NET";
msgMail.Body = strBody;

SmtpMail.Send(msgMail);

Cheers,

Hi,

Thanks for sending message. My problem is, how can i schedule database bcoz i have no control over it  bcoz it is running online sqlserver and i have only limited permission. Plz reply me if there is another solution

Hi,

You can use Windows service to do this. You can schedule the service to run daily at a particular time.

Please let me know if you require anything else.

Thank you,

Vivek Kulkarni

MCP MCAD.Net