How do I...send emails automatically in asp.net

Question

1.00/5 (3 votes)

See more:

i have two table
1) Tbl_EmailAddress
id,
emailId

2) Tbl_Product
pid,
pname,
pdetail,
startDateTime,
CloseDateTime,

now
there are some data in database tables

i want to mail my all users (om email id) when startDateTime becomes Server time

then how can i accomplish ...

mail should be send on StartDateTime (mail contain product name and details)

please help
thanks

Posted 27-Jun-14 19:53pm

teja u

Add a Solution

Comments

Awadhendra Tripathi 28-Jun-14 2:18am

So you write tbl before your table name?
so you should also write col before column name
: )

Sanjay K. Gupta 28-Jun-14 2:26am

Instead of laughing on his naming convention, you should provide a solution for his problem.:)

Awadhendra Tripathi 28-Jun-14 2:28am

Then what you done..?
you also repeating same thing : )

Sanjay K. Gupta 28-Jun-14 2:30am

The question is not clear. I think, he was talking about automated mail sending.

Sergey Alexandrovich Kryukov 28-Jun-14 2:37am

Oh, please. He should not. Is he less free person the you are? Why won't you say to yourself "I should help" and actually help?

As to that "laughing", Awadhendra actually gave IP a really valuable advice on naming. It would be good to appreciate it. Indeed, this is similar to some person who use the word "class" in class name, "application" in the name of executable file, and so one. Who says that laughing is a bad thing? We all should have more sense of humor and think of ourselves not so seriously, with certain irony...

Doesn't it makes sense?

—SA

Sanjay K. Gupta 28-Jun-14 2:30am

Do you want the mail should sent automatically?

2 solutions

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)

DamithSL · Answer 1 · 2014-06-27T20:35:00

Solution 1

you can do this using ASP.NET but you can simply do this task by writing simple console application to send emails by fetching data from database at the excution time. Schedule this exe as windows scheduled task and run it in every 5 minutes or as you need.
for other options check These answers[^]

Posted 27-Jun-14 20:35pm

DamithSL

Updated 27-Jun-14 20:36pm

v2

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2014-06-27T20:44:00

Solution 2

Read my past answer - How to send Automatic Messages from Asp.net C#?[^].

Posted 27-Jun-14 20:44pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)