ASPMail not recognizing a recordset as a recipient

[rodrigosalinas]

using dreamweaver I inserted information in database, and after inserting info, user is redirected to a thank you page where he can see all the info submitted. in the thank you page, I have a recordset based in the last insterted record. I'm using ASPMAIL and I can't send the mail to the user. code I'm using:

Set Mailer = Server.CreateObject("SMTPsvg.Mailer&quot
Mailer.FromName   = "mysite.com"
Mailer.FromAddress = "webmaster@mysite.com"
Mailer.AddRecipient rs_users.Fields.Item("name&quot.Value, rs_users.Fields.Item("email&quot.Value
Mailer.RemoteHost = "mail.mysite.com"
Mailer.ReplyTo = "webmaster@mysite.com"
Mailer.Subject    = "Your order at

http://www.mysite.com";

Mailer.BodyText   = msgBody

BUT i'm getting the error message:

Type mismatch: 'Mailer.AddRecipient'

any advice will be appreciated.

 

[Cheech]

take out "rs_users.Fields.Item("name&quot.Value, "

Cheech

[Peace][Pipe]

 

[rodrigosalinas]

I can't take ot that line because aspmail requires for the recipient to have a name and email. any more ideas?

 

[YNOTU]

this is a stab in the dark but you're missing the = on that line

 

[lebisol]

use variables assigned to values of RS.

<%' *** E-mail Vars
  Dim strFirstName
  Dim strEmail
  Dim strAccountName
  Dim strAccountPassword
     strFirstName = Users.Fields.Item(&quot;FirstName&quot;).Value
     strEmail = Users.Fields.Item(&quot;Email&quot;).Value
     strAccountName = Users.Fields.Item(&quot;UserName&quot;).Value
     strAccountPassword = Users.Fields.Item(&quot;Password&quot;).Value
%>
<%' *** SEND MAIL
Dim objCDO
Set objCDO = Server.CreateObject(&quot;CDONTS.NewMail&quot;)
objCDO.From = &quot;SOMEONE&quot;
objCDO.To = strEmail
objCDO.Subject = &quot;Thank you for registering with [URL unfurl="true"]http://mysite.com&quot;[/URL]
objCDO.BodyFormat = 0 
objCDO.MailFormat = 0 
objCDO.Body = &quot;<font face='Arial' size ='3'>&quot; &_
&quot;WELCOME &quot; & strFirstName & &quot;!&quot; &_
&quot;<br>&quot; &_
&quot;Thank you for registering with mysite&quot; &_

All the best!

> need more info?
:: don't click HERE ::

 

[lebisol]

also try recipient format of:
User <user_email@site.com>, User2 <user_2@site.com>

All the best!

> need more info?
:: don't click HERE ::