Retrieve access Memo data type by ASP and include in the mail html body

[Dilruba]

I have tried to take Memo (Access 2000) data type in a Dim variable.
After that i have send it via e-mail text. But it is not sending the vaule.

Here is the code that i have used:

<% Dim msgDb
msgDb = "Person history: " & Recordset1.Fields.Item("personh").Value %>

## here personh is a memo data type of Ms Access

<% Dim msgDb1
msgDb1 = msgDb & "Person Name : " & Recordset1.Fields.Item("name").Value & VBCrLf & VBCrLf %>

## here name is a Text data type

## send the mail

<%
Dim msg1
msg1 = msgDb1

Dim myMail

Set objMail = CreateObject("CDO.Message")
objMail.Subject = "This is the test of E-mail"
objMail.From = " "
myMail.To = ""
myMail.Bcc = ""
myMail.TextBody = msg1
myMail.Send
set myMail = nothing
%>


Output I had got in my mail is as follows:

Person history: //here i didn't got the person history

Person Name : Sumon