Place a returned recordset value in htmlbody property

  • Thread starter Thread starter Nick Ward
  • Start date Start date
N

Nick Ward

Hi
I have a recordset that returns a result for example

recName("Salutation")
returns "Mr Smith"
I can create an email from within this function quite easily:

strOrder = "Dear " & recName("Salutation") & _
vbCrLf & vbCrLf & _
"Many thanks for your enquiry , please find your quote attached
to this email." & _
vbCrLf & vbCrLf & _
"Kind Regards" & _
vbCrLf & vbCrLf & _
"Nick Ward"

However when I want to use the .htmlbody property as opposed to the .body
property ie

"<table> <tr> recName("Salutation") </tr> </table> "

it doesn't like the syntax of the quotes around the salutation. I can't
figure out how to call the value of the recordset that it will be happy
with. I know how to do it with ASP but Access has me stumped.

TIA

Nick
 
Back
Top