How can send an email with excel sheet attachment on specific time

Question

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 23-Sep-15 23:23pm

Member 10817818

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

DotNet WeblineIndia · Answer 1 · 2015-09-27T23:24:00

Solution 1

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.

Posted 27-Sep-15 23:24pm

DotNet WeblineIndia