By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,571 Members | 3,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,571 IT Pros & Developers. It's quick & easy.

E-mail from within Access

P: n/a
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

Jan 18 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Jan 19 '06 #2

P: n/a
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

Jan 19 '06 #3

P: n/a
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


Jan 19 '06 #4

P: n/a
Many thanks. I will try it out and let you know.

Miguel

Jan 20 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.