Nancy,
I found an article awhile back about emailing which covered most of my problems. I'm trying to find the article to forward to you.
Below is an exact copy of working code I use on my site where a user submits to a form for mailing and database storing. This code pulls information out of a database and sends to me.
<%
Response.Buffer = "true"
Dim strConnect, strMailer
strMailer = "
[email protected]"
%>
<!-- METADATA TYPE="typelib"
FILE="c:\program files\common files\system\ado\msado15.dll" -->
<%
Dim objRS, objComm, strID
strID = Request.Querystring("id")
Set objComm = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = strConnect
objComm.CommandText = "SELECT * FROM feedback WHERE id = " & strID
objComm.CommandType = adCmdText
Set objRS = objComm.Execute
Set objComm = Nothing
Dim strFirst, strLast, strPhone, strEmail, strContact, strCat, strMemo, strFrom, strAddedon
strFirst = objRS("first")
strLast = objRS("last")
strPhone = objRS("phone")
strEmail = objRS("email")
strContact = objRS("contactu")
strCat = objRS("catagory")
strMemo = objRS("memo")
strFrom = objRS("from")
strAddedon = objRS("addedon")
strSubject = "Harrison County Online! Feedback Form Submission"
strBody = "<HTML>" & _
"<HEAD>" & _
"</HEAD>" & _
"<BODY>" & _
"<table align=left border=0 cellpadding=0 cellspacing=0 width=500>" & _
"<tr><td align=left width=500 colspan=3><img src='http://co.harrison.ms.us/site/feedback/mailer.gif'><p></td></tr>" & _
"<tr><td align=right width=100 bgcolor=dddddd><b>Name:</b></td>" & _
"<td align=left width=5></td>" & _
"<td align=left width=395>" & strFirst & " " & _
strLast & "</td></tr>" & _
"</table>"
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From = strEmail
objMail.To = strMailer
objMail.Subject = strSubject
objMail.Body = strBody
objMail.MailFormat = 0
objMail.BodyFormat = 0
objMail.Send
Set objMail = Nothing
Response.Redirect "thankyou.asp"
%>
Don't know if this will help you at all, but it did save me a lot of hair pulling at the time. I have noticed 2 other issues with FSO.
1) The sender's email must be valid
2) You may have an issue with mail relaying.
Just my 2 cents.
HTML formatted mail goes to BadMail. Why?
