so you are saying for example....
Code:
strMessage = strMessage & "<br>City: "&city
produces
but nothing else?
If this is what you mean (and having looked at the code I think it is) the problem is that you have not set any value for the city variable.
When you get a recordset it doesn't automagically assign the values int he recordset to anything, you need to do that yourself. So in this case you would want something like
Code:
city = rsUserinfo("city")
alternatively you could use the recordset values directly, like this
Code:
strMessage = strMessage & "<br>City: " & rsUserinfo("city")
HTH