E-mail from within Access

[Miguel]

I have a simple issues database in which the issue can be assigned to
an individual via e-mail. The e-mail sendobject function is working
correctly, except that the notes from the memo field are being
truncated. The memo field can have an unlimited number of characters,
but is there a limit as to what will be copied into the e-mail body. I
would rather not have to cut and paste notes from the memo field to the
e-mail if at all possible. That part of it is being copied correctly
tells me something is working correctly.

Regards,
Miguel

[Linda Burnside]

Hi Miguel,

I built something similar once, and I didn't have the size limitation (256
characters), so I know it can be done. I'm wondering if it might be the
format of your email. In my application, the format of the email was html.
Just curious.

Linda
"Miguel" <mj********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I have a simple issues database in which the issue can be assigned to
an individual via e-mail. The e-mail sendobject function is working
correctly, except that the notes from the memo field are being
truncated. The memo field can have an unlimited number of characters,
but is there a limit as to what will be copied into the e-mail body. I
would rather not have to cut and paste notes from the memo field to the
e-mail if at all possible. That part of it is being copied correctly
tells me something is working correctly.

Regards,
Miguel

[Miguel]

Dear Linda:

Thank you for the advice. No the e-mail format is not HTML. If you are
suggesting that if it were HTML and then it would work, I can only
change the format after the e-mail window has been opened, I do not
know how to do it before. Besides, each user would have to do the same.
I would rather have something execute automatically.

Miguel

[Linda Burnside]

Hello again,

Here is the code from the application I developed with regard to setting up
the email. Maybe you try something similar:

Set msg = appOutlook.CreateItem(olMailItem)

With msg
..BodyFormat = olFormatHTML
..HTMLBody = strBody1 & strBody2 & strBody3
..To = strEmailRecipient
..Subject = strSubject
..BCC = strBCC
..Display

End With
"Linda Burnside" <linda@nospam_burnsidebiz.com> wrote in message
news:UV****************@newssvr14.news.prodigy.com ...

Hi Miguel,

I built something similar once, and I didn't have the size limitation (256
characters), so I know it can be done. I'm wondering if it might be the
format of your email. In my application, the format of the email was
html. Just curious.

Linda
"Miguel" <mj********@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I have a simple issues database in which the issue can be assigned to
an individual via e-mail. The e-mail sendobject function is working
correctly, except that the notes from the memo field are being
truncated. The memo field can have an unlimited number of characters,
but is there a limit as to what will be copied into the e-mail body. I
would rather not have to cut and paste notes from the memo field to the
e-mail if at all possible. That part of it is being copied correctly
tells me something is working correctly.

Regards,
Miguel

[Miguel]

Many thanks. I will try it out and let you know.

Miguel