467,074 Members | 922 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

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

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
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
Jun 28 '07 #1
  • viewed: 1139

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Masterblue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.