Get String from recordset field

[patricktwo]

We are upgrading our system to server2003 and have to change the method used for email.
We get a recordset from a database as follows:

toEmail = recordset("email")

When we try to send mail with this it errors out. It seems that a field object is being moved to the toEmail variable.

I have tried:
toEmail = recordset("email").value

This causes the same error.

Any ideas, help

 

[HarleyQuinn]

Try:

toEmail = Recordset!email

That might work for you.

Hope this helps

Harleyquinn

---------------------------------
For tsunami relief donations

 

[comaboy]

...or

RecordSet.Fields("email").Value

- Apologies in advance, stupid question: You ARE using something like
rs("Email")
and NOT the reserved word RecordSet, arn't you...