I have a requirement like, I need to send an emails to all clients at 9:00 pm every day. I have the code for email send. I just want to know how do we schedule program to run at certain time in asp.net application. Do we need to open that website all the time ?
View 1 RepliesI need to write a stored procedure to schedule a job that will send automatic email to customers based on some condition as follows:
1. I have two tables. One table is table1 like the following:
Name Date1 Date2 Date3 Rahim, Khan 29'10 30'11 25'08 Karim,Abedin 12'10 28'11 26'09 Fahad, Alam 26'10 12'11 25'10 Another Table is table 2 like the following:
Name Email Rahim,Khan rahim@yahoo.com Karim,Abedin karim@yahoo.com Fahad, Alam falam@yahoo.com In table 1 the date format is in format where 30'11 mean work week is 30 and 11 means last two digits of the year.
2. Now , I need to write a stored procedure that will check :
a) What is current work week and current year?
b) It will then determine the difference between the current work week (now 37) and work week mentioned in date (Date1, Date2 and Date3) columns from table1 and if for current year(it's 2010) at least one difference in each row is>=8 then it should send an automatic email to the corresponding email address of Name column using the relation between Table1 and table2. For example: For first record in Table1 the three difference is: 37-29=8, 37-30=7 and 37-25=12. There are two differences >=8, but only first difference is for year 2010 and third one is not for current year. But, since at least one difference in this row satisfies condition (That means >=8 for year 2010)hence email message should be sent to the address rahim@yahoo.com using relation of table1 and table2.
I know how to set a schedule job in SQL mail but I need this stored procedure to run this job on daily basis.
I have a web site in asp.net(C#). And want to add an automatic email sending functionality in it, i.e. an email will be send daily and weekly(both on a particular time) to all the stock holders about the orders details placed by registered users. How can I do this in asp.net(C#)?
View 21 Repliesis it possible to send an automatic email to a certain user through sql express? im using sql express to handle my auction so i need to email the winner when endate =Now.
View 1 RepliesI'm using ASP.Net with VB (Visual Web Developer 2010) and SQL(Management Studio Express 2008) to create a website that keeps track of employee subscriptions.A date is entered into my database whenever an employee makes a subscription.I need to find a way to send an automatic email to each employee when the current date exceeds the subscription date by one year.
I am unable to use an SQL job as I only have SQL MS express.From other posts I have read it seems the best way to do this is to create a webservice to send emails but I am unsure of how to get the email address for each employee from the database to the web service?Do you guys think a web service is the best way to do this?
How to send email from asp application?
View 1 Replies my application sends an email to a user. now the email body has a hyperlink, which shows as hyperlink to some recepients and as plain text to some other recepients. below is the code i used to send email from the application
[code]....
I am trying hard from the past 2 days to Send mail to my gmail account. But I am not able to do so
Only Exception i am getting is "Failure sending mail."
If i am giving wrong username and password then it is giving the exception
" The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required. Learn more at"
0
2
I get error when sending email from web app:
The server rejected one or more recipient addresses. The server response was: 451 Greylisted, please try again in 900 seconds
I have very simple contact us page to send inquiry email.Following is the code behind file
[Code]....
It has been over a week and still getting this erorr.
I want to sent automatic mails to my clients to that date, on which they selected reminder. I went through article for window service and using sql server, but I didn't understand its working, any alternate option, is it possible to use google calendar in my website and when calendar date is set to some event then google alert set automatically to client email, and google alert sent to that email automatically...
View 1 Replieshow to generate auto mails to user who hav subscribed when ever any new product is added
View 1 RepliesI followed this link, it works fine with English Text. [URL] ....
My problem is when I am adding Arabic text to the message body it displays ???? format.
i have code for forgot password using gmail account. But i want to send password for multiple domains like yahoo,rediffmail and more.
View 1 Replieshow to display Chart in Email body and excel attachment.
View 1 Repliesi will enter an email address in textbox i have button on the click of button i would like to send a mail Hello to the mail address provider
View 1 RepliesThese are sender settingcode in web.config
<configuration>
<appSettings>
<add key="Host" value="smtp.gmail.com"/>
<add key="EnableSsl" value="true"/>
<add key="UserName" value="neda@gmail.com"/>
<add key="Password" value="xxxx"/>
<add key="Port" value="587"/>
</appSettings>
<connectionStrings/>
here is sender email but i want there wasn't any email address.I mean i want when users click on button and send me an email there wasn't any email address in sender details.
iam new to sending automatic email reminders can anyone tell me how to do that, and plus i have never used sms technology , but i want to implement this one in my current project can you give me any idea how to do this together, sending automatic email n sms by checking today's date , you kno the reminder part,
View 3 Repliesi am trying to send emails to internal as well external email id(like gmail,yahoo,rediff etc.) .but the problem is that i can send the email to internal email id and recieve it but when i try to send the mail to external email id iam not able to receive the email. the process runs fine cause no errors are occurring.
SmtpClient emailClient;
emailClient = new SmtpClient("80.0.0.120", 252);
MailMessage message = new MailMessage("a.b@abc.com", a.b@glass.com", "Report", "Dear All,");
message.IsBodyHtml = true;
message.Body ="Dear All,"+"<br/>"+ "Please find the attached file.";
System.Net.Mime.ContentType mimeType = new System.Net.Mime.ContentType();
message.Attachments.Add(new System.Net.Mail.Attachment("Report.xls", mimeType));
emailClient.Credentials = new System.Net.NetworkCredential("a.b", "pass123");
emailClient.UseDefaultCredentials = false;
emailClient.Send(message);
emailClient = null;
message.Dispose();
I know it is possible to do this using windows service but I am using a shared hosting and so that choice is out. Also the ms sql stored pocedure is also not ideal for my problem as i dont have administrative previlages in the database. My requirement is to send a url or the data in that particular url to the administrator to notify him about the expiry of registration of the users in the system. I need to do this once in every month and I need to do this frm asp.net.
View 5 Repliesmy web application contain insurance due date field(in TextBox,which is enterd by user),and i need automatic email alert generation for this field 1 month before the date specified in the textbox to specific email address... how can i code my requirement in c#...can any one one suggest altenate option if my concept is wrong.
View 14 Replieshow Can i Send Email With Message Using Master Page in Asp.net?
EMail Sending PopUp Open In All Pages To Provide The User Sending Email Facility From All Pages...
I am developing ecommerce website and i have some page where to send automatic mails , How to assign mail templates with particular module with mail templates , how to use dynamic email templates for sending automatic emails in asp.net ?
View 1 RepliesI need to create an email application that support sending and receive email application.
View 1 Repliesin my web i want to send email to distribution list instead of email addresthis is my code:
message.From = New MailAddress("Innovate_Web@KISR.EDU.KW")
message.To.Add(New MailAddress("mmahdi@safat.kisr.edu.kw"))
'message.To.Add(New MailAddress("innovate@safat.kisr.edu.kw"))
message.Subject = "Email from contact page in Innovate Web"
message.BodyEncoding = Encoding.UTF8
[code]...
I am trying to send an email from asp.net using a google apps email.
I found this question which did not resolve the issue
Send Email via C# through Google Apps account
The part that I am really confused about is that it works with these settings
<smtp from="****@gmail.com" deliveryMethod="Network">
<network host="smtp.gmail.com" port="587"
userName="****@gmail.com" password="****"[code]....
and get the following error message
"The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required."
I found this article as well http://www.google.com/support/forum/p/Google+Apps/thread?tid=2cbb54572fea6939&hl=en and worked through this but that did not resolve me issue either.