Sending an SMTP email with Attachment from server that requires authentication



This isn't too hard, but points will go to whomever hits all the requirements first.



1. I have an Access database with one table called "EmailAddresses" with one field called "EmailAddress" located at "c:\reunion\reunion.mdb"

2. I need to select all the rows from this table and send an email to each address individually.

3. I'm going to start out with text email but I'd like to do HTML.

4. The SMTP server is not on the localhost and requires authentication - it's at my ISP.  

5. The email will have one attachment.

6. I'm not paying for an SMTP component.  A freebee is acceptable as long as I can send at least 250 emails a day.

7. This will be in a C# application and not ASP.NET


Thanks!

Michael G


mgeiserAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tom KnowltonWeb developerCommented:
This does not fill ALL of the requirements.....but should ALMOST get you where you need to be:



using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using System.Web.Mail;


namespace WindowsApplicationEmail
{
      /// <summary>
      /// Summary description for Form1.
      /// </summary>
      public class Form1 : System.Windows.Forms.Form
      {
            private System.Windows.Forms.Button button1;
            /// <summary>
            /// Required designer variable.
            /// </summary>
            private System.ComponentModel.Container components = null;

            public Form1()
            {
                  //
                  // Required for Windows Form Designer support
                  //
                  InitializeComponent();

                  //
                  // TODO: Add any constructor code after InitializeComponent call
                  //
            }

            /// <summary>
            /// Clean up any resources being used.
            /// </summary>
            protected override void Dispose( bool disposing )
            {
                  if( disposing )
                  {
                        if (components != null)
                        {
                              components.Dispose();
                        }
                  }
                  base.Dispose( disposing );
            }

            #region Windows Form Designer generated code
            /// <summary>
            /// Required method for Designer support - do not modify
            /// the contents of this method with the code editor.
            /// </summary>
            private void InitializeComponent()
            {
                  this.button1 = new System.Windows.Forms.Button();
                  this.SuspendLayout();
                  //
                  // button1
                  //
                  this.button1.Location = new System.Drawing.Point(96, 56);
                  this.button1.Name = "button1";
                  this.button1.Size = new System.Drawing.Size(96, 23);
                  this.button1.TabIndex = 0;
                  this.button1.Text = "Generate Error";
                  this.button1.Click += new System.EventHandler(this.button1_Click);
                  //
                  // Form1
                  //
                  this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
                  this.ClientSize = new System.Drawing.Size(292, 266);
                  this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                                                                                              this.button1});
                  this.Name = "Form1";
                  this.Text = "Form1";
                  this.ResumeLayout(false);

            }
            #endregion

            /// <summary>
            /// The main entry point for the application.
            /// </summary>
            [STAThread]
            static void Main()
            {
                  Application.Run(new Form1());
            }

            private void button1_Click(object sender, System.EventArgs e)
            {

                  ReadDB();
                  //SendEmail("blahblah@yahoo.com","blahblah@yahoo.com","","Subject:  Hello","A new message");

            }

            public void ReadDB()
            {
                  string  strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\reunion\\reunion.MDB";
                  string strSQL = "SELECT * FROM EmailAddresses" ;
                  // create Objects of ADOConnection and ADOCommand
                  OleDbConnection myConn = new OleDbConnection(strDSN);
                  OleDbCommand myCmd = new OleDbCommand( strSQL, myConn );
                  OleDbDataReader datareader = null;
                  try
                  {

                        myConn.Open();
                        datareader = myCmd.ExecuteReader();
                        while (datareader.Read() )
                        {
                              //Console.WriteLine( "Address:{0}", datareader["EmailAddress"]);
                              SendEmail("you@yourdomain.com",datareader["EmailAddress"],"","My Subject","My Message");
                        }
                  }
                  catch (Exception e)
                  {
                        Console.WriteLine("Oooops. I did it again:\n{0}", e.Message);
                  }
                  finally
                  {
                        myConn.Close();
                  }
            }
            
            public int SendEmail(string From, string To, string CarbonCopy, string Email_Subject, string Email_Body)
            {
                  try
                  {
                        MailMessage MyMail = new MailMessage();
                        MyMail.From = From;
                        MyMail.To = To;
                        MyMail.Cc = CarbonCopy;
                        MyMail.Subject = Email_Subject;
                        MyMail.Body = Email_Body;
                        //      SmtpMail.SmtpServer = "localhost";
                        SmtpMail.Send(MyMail);                    
                        return 0;                              
                  }
                  catch(Exception e)
                  {
                        return 1;                              
                  }                  

            }
      }

      
}

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DivinityCommented:
To send the message to an SMTP server that requires authentication, add the following to knowlton's SendEmail code:

MyMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); // Basic authentication.
MyMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", username); // Username.
MyMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", password); // Password.

To add an attachment, add the following code:

MailAttachment myAttachment = new MailAttachment("c:\attach\attach1.txt", MailEncoding.Base64);
MyMail.Attachments.Add(myAttachment);

I think that knowlton's code and mine, cover all your requirements.
mgeiserAuthor Commented:
Cool!

I'll test this weekend and give some points on Sunday.


DivinityCommented:
While I appreciate the recommendation, its not entirely fair I think. As I have mentioned in my comment, my code PLUS knowltons code should give the proper results. So my recommendation would be Accept: knowlton, Assisted Answer: Divinity
Tom KnowltonWeb developerCommented:
Thank you, Divinity.

Thank you, mgeiser.

Glad it worked out.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C#

From novice to tech pro — start learning today.