How to send email to a client.

Question

I want to send a mail to a client at the end of each month which contain a excelsheet having information present in database for that particular month. So please tell me what i should do to automatically mail the excelsheet to the given mail id.

Rajeesh Menoth · Answer

Hi The solution of Amitesh Verma is correct one.smtp is also work in server.. If you don't know sending email using asp.net and c# : click here Ref the below articles : 1) http://www.c-sharpcorner.com/UploadFile/ee01e6/create-windows-service-and-send-mail-daily-on-fixed-time-usi575/

Rajeesh Menoth · Answer

Hi Without an app password it's working fine..I think you face some other in that your solution.that's why the error showing or the app is not disable...: )

Ashutosh Tripathi · Answer

Yes sir your post is very helpful because it leads me to correct solution. Sir but we can improve this link http://www.c-sharpcorner.com/Blogs/49373/smtp-server-requires-a-secure-connection.aspx by generating app password which work fine without any compromise with security.

Rajeesh Menoth · Answer

Hi Welcome always Ashutosh Tripathi :).In my solutions are helpfull for you then accept the answer.it help for others..

Ashutosh Tripathi · Answer

rajesh sir thank you for your help finally i did this by generating the app password for my email id

Rajeesh Menoth · Answer

Hi check Your gmail password is correct or not ? ashutosh14794@gmail.com? afterward check while you are setted any 2 factor authentication message in gmail then remove it..

Ashutosh Tripathi · Answer

string from = ashutosh14794@gmail.com; //To address string to = ashutosh1747@gmail.com; //From address MailMessage message = new MailMessage(from to); string mailbody = In this article you will learn how to send a email using Asp.Net & C#; message.Subject = Sending Email Using Asp.Net & C#; message.Body = mailbody; message.BodyEncoding = Encoding.UTF8; message.IsBodyHtml = true; SmtpClient client = new SmtpClient(smtp.gmail.com 587); //Gmail smtp System.Net.NetworkCredential basicCredential1 = new System.Net.NetworkCredential(ashutosh14794@gmail.com ******); client.EnableSsl = true; client.UseDefaultCredentials = false; client.Credentials = basicCredential1; try { client.Send(message); } catch (Exception ex) { throw ex; }

Rajeesh Menoth · Answer

Hi Can you show your code..

Ashutosh Tripathi · Answer

Yes sir i am getting 5.5.1 authentication error. the message is 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 Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Net.Mail.SmtpException: 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

Rajeesh Menoth · Answer

Hi Which error you got ? 5.5.1 ? Check this below option also.. Enter the correct login password. To remove 2-Step Verification.

Ashutosh Tripathi · Answer

I changed the less secure app setting but it is still showing the same error. So please help sir

Rajeesh Menoth · Answer

Hi Try to use the namespace using System.Text; In my article is also provide the 5.5.1 error detail.. Check this : http://www.c-sharpcorner.com/Blogs/49373/smtp-server-requires-a-secure-connection.aspx

Ashutosh Tripathi · Answer

Rajesh sir this line is showing error message.BodyEncoding = Encoding.UTF8; The name Encoding does not exist in the current context. So i changed this line to message.BodyEncoding = System.Text.Encoding.UTF8; Now it is compiled and run on browser. At button click to send the mail it is showing below error on localhost. And on my gmail i get a mail from gmail team that someone is tried to sign in to my account. What i should do? 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

Rajeesh Menoth · Answer

Hi Sending emails using C# : Click here Ref this link also : Click here Check Amitesh Verma solution.

Ashutosh Tripathi · Answer

yes i read all the three links which u have provided me.

Rajeesh Menoth · Answer

Hi Ashutosh Tripathi please check my solution.in that article clearly mention the details.in that article code is also working in server also.

Amitesh Verma · Answer

Ashutoshhave u read the provided links???

Ashutosh Tripathi · Answer

Sir if i want to send mail from my server to gmail what things should i do.

Raja T · Answer

Hi For your requirement there 2 ways 1. you can schedule the job in sqlserver 2. you can create windowservies in c# and schedule in server system.

Amitesh Verma · Answer

SMTP works on server also.you just need to provide the basic rights over server http://www.aspsnippets.com/Articles/Send-email-using-Gmail-SMTP-Mail-Server-in-ASPNet.aspx

Ashutosh Tripathi · Answer

thank you amitesh sir for your reply but in he first link it is using smtp which will work only on localhost and i need to send an attachment with mail. so please provide some more suggestion according to my problem.

Amitesh Verma · Answer

http://www.aspsnippets.com/Articles/Automatically-send-emails-daily-at-specific-time-using-Windows-Service-in-C-and-VBNet.aspx http://www.codeproject.com/Articles/69698/Set-the-Time-for-E-Mail-Sending-from-your-NET-Appl