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"))


'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 = "" '' this is the From Address

newMail.To = "" '' this is TO Address

'newMail.Cc = "" '' 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.Fields.Add("", "1")

newMail.Fields.Add("", "username")

newMail.Fields.Add("", "password")

SmtpMail.SmtpServer = "mailserver"


End If

End If

End While

myConnection.Close() 'Close the connection

End Sub