Email will not send my visual studio 2003 project

[kenn_rosie]

Email will not send my visual studio 2003 project

1. I am using MSDE, IIS, Visual studio 2003, 1.1 netframework, I have mail Outlook and msn homail,

2. these are installed on windows xp

3. Can I send email if I only have msde and not a regular server?

4. The project works except the sending of the email

5. I thought I have coded below correctly, but I do not receive emails

Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)

' Fires when the application is started

'1. Create a connection

Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))

myConnection.Open()

'2. Create the command object, for the query

Const strSQL As String = "Select LastUpdated, ProductId from products "

Dim objCmd As New SqlCommand(strSQL, myConnection)

Dim objDR As SqlDataReader

Dim att

objDR = objCmd.ExecuteReader()

While (objDR.Read)

If (Not (objDR("LastUpdated") Is DBNull.Value)) Then

If (Date.Compare(objDR("LastUpdated"), Today.Date) = 0) Then

Dim newMail As New MailMessage

newMail.From = "from@from.com" '' this is the From Address

newMail.To = "kenn_rosie@msn.com" '' this is TO Address

'newMail.Cc = "hadeedian@hotmail.com" '' this is TO Address

newMail.Subject = "Change in Product Rate"

newMail.Body = " Dear Ken, " & "Please review attached email for product ID: " & objDR("ProductID") & "Thank you," & "Kenn()"

att = New MailAttachment("C:\Inetpub\wwwroot\GrocerToGo\Product_Changed.doc")

newMail.Attachments.Add(att)

newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1")

newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "username")

newMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "password")

SmtpMail.SmtpServer = "mailserver"

SmtpMail.Send(newMail)

End If

End If

End While

myConnection.Close() 'Close the connection

End Sub

[Phil Weber]

See if this helps: http://www.systemwebmail.com/