| | |
Send automatic email
Please support our ASP.NET advertiser: Intel Parallel Studio Home
Thread Solved |
I am working on a web-based app, and I need to implement a function whereby it checks the dates daily, and send reminder email automatically.
May I know how can I do that? I saw some websites that mentioned about Console Application and Windows Scheduler.
Is that what I need? If so, how can I link to my app?
Otherwise, what are the methods that are available?
I'm new to C# and asp.net, please help.
Thanks.
May I know how can I do that? I saw some websites that mentioned about Console Application and Windows Scheduler.
Is that what I need? If so, how can I link to my app?
Otherwise, what are the methods that are available?
I'm new to C# and asp.net, please help.
Thanks.
Serene Joey
hi,
there are different options to send email automatically
1) you can use windows schedular in u r computer to send them
the following urls will help u :
http://blogs.msdn.com/dditweb/archiv...0_-Part-I.aspx
http://www.gridviewguy.com/ArticleDe...x?articleID=32
2)u can achieve the same functionality using sql server,if u are using that in u r project.
first u need to configure the sql to send emails the procedure and requirements for a computer to send email are given below,hope it helps
Requirements for Domain User Account
All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).-->the server account we r using should be db owner.
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.-->go to control panel->administrator tools->services->local security settings->local policies->user rights assignment->double click we will get logon as service->check whether the account is included in the list displayed otherwise add
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.
start->run>regedit>HKEY_LOCAL_MACHINE>Software>
Microsoft>mssqlserver>right click and check for permisions and check whether u r account is listed or not
HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQL$Instancename. HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib. start>run>regedit>HKEY_LOCAL_MACHINE>System>
currentcontrolset>services>mssqlserver>right click and check for permisions and check whether u r account is listed or not.
Even after checking permissions if u get error then it may be due to u r password.check whether u have typed correct password.if neccessary change u r password.
the detailed procedure for configuring sql mail is given in http://blogs.techrepublic.com.com/wi...windows/?p=164
there are different options to send email automatically
1) you can use windows schedular in u r computer to send them
the following urls will help u :
http://blogs.msdn.com/dditweb/archiv...0_-Part-I.aspx
http://www.gridviewguy.com/ArticleDe...x?articleID=32
2)u can achieve the same functionality using sql server,if u are using that in u r project.
first u need to configure the sql to send emails the procedure and requirements for a computer to send email are given below,hope it helps
Requirements for Domain User Account
All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).-->the server account we r using should be db owner.
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.-->go to control panel->administrator tools->services->local security settings->local policies->user rights assignment->double click we will get logon as service->check whether the account is included in the list displayed otherwise add
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.
start->run>regedit>HKEY_LOCAL_MACHINE>Software>
Microsoft>mssqlserver>right click and check for permisions and check whether u r account is listed or not
HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQL$Instancename. HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib. start>run>regedit>HKEY_LOCAL_MACHINE>System>
currentcontrolset>services>mssqlserver>right click and check for permisions and check whether u r account is listed or not.
Even after checking permissions if u get error then it may be due to u r password.check whether u have typed correct password.if neccessary change u r password.
the detailed procedure for configuring sql mail is given in http://blogs.techrepublic.com.com/wi...windows/?p=164
Hi, Thanks for your reply.
Erm, if I deploy this website app to the web-server,
I should be using method two. am I correct?
Erm, if I deploy this website app to the web-server,
I should be using method two. am I correct?
•
•
•
•
hi,
there are different options to send email automatically
1) you can use windows schedular in u r computer to send them
the following urls will help u :
http://blogs.msdn.com/dditweb/archiv...0_-Part-I.aspx
http://www.gridviewguy.com/ArticleDe...x?articleID=32
2)u can achieve the same functionality using sql server,if u are using that in u r project.
first u need to configure the sql to send emails the procedure and requirements for a computer to send email are given below,hope it helps
Requirements for Domain User Account
All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL Server\Mssql).-->the server account we r using should be db owner.
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.-->go to control panel->administrator tools->services->local security settings->local policies->user rights assignment->double click we will get logon as service->check whether the account is included in the list displayed otherwise add
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.
start->run>regedit>HKEY_LOCAL_MACHINE>Software>
Microsoft>mssqlserver>right click and check for permisions and check whether u r account is listed or not
HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQLServer.
-or- for any named instance: HKEY_LOCAL_MACHINE\System\CurrentControlset\Services\MSSQL$Instancename. HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib. start>run>regedit>HKEY_LOCAL_MACHINE>System>
currentcontrolset>services>mssqlserver>right click and check for permisions and check whether u r account is listed or not.
Even after checking permissions if u get error then it may be due to u r password.check whether u have typed correct password.if neccessary change u r password.
the detailed procedure for configuring sql mail is given in http://blogs.techrepublic.com.com/wi...windows/?p=164
Serene Joey
hi,
i think the thread is not working.check out this :
http://search.techrepublic.com.com/i...uring+sql+mail
i think the thread is not working.check out this :
http://search.techrepublic.com.com/i...uring+sql+mail
Hi, thanks for your reply.
I am not able to install that to my clients' computer so I think I'll go for method two.
Erm, I need to ask you something.
My database is using MS SQL Server.
So if my users don't have to login to the system and the database is able to trigger the method (sending email accordingly) itself?
Sorry, I don't understand about database mail.
Thanks for your reply.
I am not able to install that to my clients' computer so I think I'll go for method two.
Erm, I need to ask you something.
My database is using MS SQL Server.
So if my users don't have to login to the system and the database is able to trigger the method (sending email accordingly) itself?
Sorry, I don't understand about database mail.
Thanks for your reply.
Serene Joey
Hi.. I've developed the console application already.
Now I have a question.
In the end, the database which is attached to my web application will be deployed in a web server.
Will this console application (install in one of my user's PC) connect to that database?
The connection string is the same.
Is there anything I've to do or I can just install the exe file to my user's PC and it will be link to the database in the web server?
Now I have a question.
In the end, the database which is attached to my web application will be deployed in a web server.
Will this console application (install in one of my user's PC) connect to that database?
The connection string is the same.
Is there anything I've to do or I can just install the exe file to my user's PC and it will be link to the database in the web server?
Serene Joey
Thanks for your reply.
actually I didn't use SQL server to send the email.
I need a function whereby i retrieve the email address if there is no response from the users' clients after 3 days.
My Console Application contained the sql statements and the Stmp mail..
It's working if I run.. But still, I'm not too sure if this is the method I should use.
Sorry to trouble you.
actually I didn't use SQL server to send the email.
I need a function whereby i retrieve the email address if there is no response from the users' clients after 3 days.
My Console Application contained the sql statements and the Stmp mail..
It's working if I run.. But still, I'm not too sure if this is the method I should use.
Sorry to trouble you.
Serene Joey
I was reading your problem and wanted to say that 'greeny' is right. However there is a problem with using a Console application and scheduler - many IT admins will not like that option. Running the scheduler requires and administrator's user and if that user changes his password or is deleted the process will stop running. Another option you might use is using a cache refresh process in .NET. Using that option how ever does not let you good control over the time the method runs. I think the SQL option is the cleanest but requires an friendly DBA
Shaul
![]() |
Similar Threads
- setting up an automatic email reply from a form. (Site Layout and Usability)
- Automatic mail using jsp and javamail (JSP)
- How do i Send and Receive Email with Attachment (Visual Basic 4 / 5 / 6)
- Automatic email (PHP)
- Automatic email creation in cpanel ----PHP (PHP)
- Using PHP to Send Email to a single DB list member every 24 hrs. (PHP)
- Automatic email reply to Form (Site Layout and Usability)
- send a sms when a new email arrives (ASP)
Other Threads in the ASP.NET Forum
- Previous Thread: Reporting Service Problems
- Next Thread: Strange problem with vs 2005 when starting application
| Thread Tools | Search this Thread |
.net 2.0 3.5 ajax alltypeofvideos appliances asp asp.net beginner box browser businesslogiclayer button c# c#gridviewcolumn cac checkbox class compatible confirmationcodegeneration content contenttype countryselector courier dataaccesslayer database datagrid datagridview datalist deployment development dgv dialog dropdownlist dropdownmenu dynamic dynamically edit embeddingactivexcontrol fileuploader fill findcontrol flash flv forms gridview gudi homeedition iis javascript jquery list listbox menu microsoft mouse mssql nameisnotdeclared news novell numerical opera order panelmasterpagebuttoncontrols problem radio ratings redirect registration relationaldatabases reportemail schoolproject search security serializesmo.table sessionvariables silverlight smoobjects software sql sql-server ssl tracking treeview validatedate validation vb.net videos vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment webprogramming webservice xml xsl





