Click here to Skip to main content
14,937,132 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
My requirement is to send an email with excel sheet attachment with a specific time in ASP.NET MVC4. That means i have an web based application which is develop on ASP.NET(MVC4)razor with ADO.NET so my requirement is to fetch all entry from database and convert to excel sheet then send every days record on every morning at 06:00AM what can do????
Posted
Comments
[no name] 24-Sep-15 14:37pm
   
Do you want to send e-mail through ASP.NET MVC website. It may slow down your website.

It is better to use a background process which will execute at a particular time. You can use Windows Scheduler or WindowsService using Console app or any other third party tool like Quartz.net.

1 solution

Hello,

You can create one windows service(scheduler). In that scheduler you can write the logic to Fetch the records from database & Create excel file & keep that in a Temp folder with the date and Send that file via email to the desired Email ID.

This will fulfill your Requirement.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900