CDONTS not rs.movenext & start new email

[jcroft]

What have I done wrong?? this code produces and sends one email to each of entries in database, but the email contains copies of the previous emails in addition to the correct one...make sense??

if rs.EOF = false then
While rs.EOF = false
email = rs("Email&quot
'sending email to customer service
Set MyCDONTSMail = CreateObject("CDONTS.NewMail&quot
MyCDONTSMail.MailFormat = cdoMailFormatMIME
MyCDONTSMail.From = "whoever@home.com"
MyCDONTSMail.To= email
MyCDONTSMail.bCc= "jjj@mmm.com"
MyCDONTSMail.Subject= Request.Form("Subject&quot
MyCDONTSMail.BodyFormat = cdoBodyFormatHTML
MyBody = MyBody & &quot;To: &quot; & rs(&quot;fname&quot & &quot; &quot; & rs(&quot;lname&quot & &quot;<br><BR>&quot;
MyBody = MyBody & &quot;From: &quot; & &quot;Mr. Magoo&quot; & &quot;<br><BR>&quot;
MyBody = MyBody & body & &quot;<br><BR>&quot;
MyBody = MyBody & &quot;<A href=

http://managementemail/salesrespond.asp?ID=&quot;

& rs1(&quot;ID&quot & &quot;and?number=&quot; & rs(&quot;number&quot & &quot;>&quot; & &quot;Click Here to Respond&quot; & &quot;</A>&quot; & &quot;<br>&quot;
MyCDONTSMail.Body= MyBody
MyCDONTSMail.Send
set MyCDONTSMail=nothing
rs.MoveNext
WEND
end if june.croft@sfmco.com

--only those that do not try, fail--

 

[SashiRaveendran]

Your MyBody variable looks like its is incorrectly formatted
, try using the following...
MyBody = MyBody & body & &quot;<BR><BR>&quot;
MyBody = MyBody & &quot;<A href=&quot;&quot;

http://managementemail/salesrespond.asp?ID=&quot;

& rs1(&quot;ID&quot & &quot;&number=&quot; & rs(&quot;number&quot & &quot;&quot;&quot;>Click Here to Respond</A><br>&quot;

 

[lobstah]

When you start defining the body of the message, you start with MyBody = MyBody & ...... etc., which will take the MyBody message from the previous email. If you remove the MyBody & from the first statement filling the MyBody variable, you should be all set:


MyCDONTSMail.BodyFormat = cdoBodyFormatHTML
MyBody = &quot;To: &quot; & rs(&quot;fname&quot & &quot; &quot; & rs(&quot;lname&quot & &quot;<br><BR>&quot;

 

[jcroft]

lobstah....you are a life (and last nerve) saver...thank you.
June june.croft@sfmco.com

--only those that do not try, fail--