Memo field truncated when SendObject is used

J

Julia Grant

All,

I've looked at other postings but have not found an answer
to my question.

I have a macro I use to run a query and create an e-mail
that sends an Excel file. One of the fields in the query
is a memo field.

If I run the query and save it as an Excel file to my hard
drive all the text in the memo field is available. If I
run the query and send it via e-mail the text in the memo
field is cut off at 255 characters. Does any one know why
this happens? Any adivce to offer - (other than the
ovbious - save it to my hard drive)?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text box in report is truncating memo field at 255 characters 2
Memo field is truncating in group heading of an Access 2007 report 3
Memo field cuts text 1
Memo field truncating in report 3
conditional format truncates memo field 1
Make Table Query Truncating Memo Field at 255 Characters 1
Truncating memo field 3
truncation of memo field supplied by DLookUp in a report 8

Top