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
| 
