including database info in a string

[sthmpsn1]

I have the following variable that is equal to some text which I also want to include some database info. How would I correctly write this.

BodyString = "The following user " & rs2.Fields.Item("firstname&quot.Value rs2.Fields.Item("lastname&quot.Value & " has submited his information for the health drawnings"

 

[BBirkett]

BodyString = "The following user " & rs2("firstname&quot &
rs2("lastname&quot & " has submited his information for the health drawnings"


This will do the trick Brett Birkett B.Comp
Systems Analyst