SendObject -- Message Text Truncates

Hello, experts!

I have a ticket management database that I want to use to send emails to users once an issue is resolved (a button is clicked, then a macro is run using the SendObject action).  Everything works fine with the exception that the Message Text is truncated after 250 characters (including spaces).  The Message Text is set to "=[Comment]", where [Comment] is a memo field in my ticket table.  Any help is much appreciated.  

Also, I'm not opposed to using a different method, if it will resolve the issue of truncation.

I'm using Access 2003.

Thanks!
mixxieAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Leigh PurvisDatabase DeveloperCommented:
What's the code you're using?
And where is this launched from?
Is the text in the control itself not truncated?

The limit for text through SendObject as a total should be about 2000 characters (including the To, Subject etc arguments if memory serves).
0
mixxieAuthor Commented:
There's not really any code, since I'm using the macro, but here it is anyway:

Issues Form Macros
-----------------------------------------
cmdEmailUser : On Click
SendObject
Object Type: (blank)
Object Name: (blank)
Output Format: (blank)
To: =Nz(DLookUp("[E-Mail Address]","Users","ID=" & Nz([Submitted By],0)))
CC: (blank)
Bcc: (blank)
Subject: ="Status Update for Ticket " & [ID] & ": " & [Title]
Message Text: =[Comment]
Edit Message: Yes
Template File: (blank)

Form:
----------------------------
btnSendEmail Properties
On Click: Issues Form Macros.cmdEmailUser : On Click

And no, the text itself is not truncated.  I can query or report on the text and the full content is displayed.
0
Leigh PurvisDatabase DeveloperCommented:
Ah OK.
Missed the reference to a Macro.  (Out of my comfort zone now ;-)

I honestly don't know how a macro would behave in this situation.
I suppose you could try firing a function.

Can I ask though - where are the values
 [ID], [Submitted By], [Title], and importantly [Comment]
coming from?
(And why do you have to Dlookup the email address - when those others seem so readily available - from somewhere).
0
rockiroadsCommented:
I think the export functionality has limits on the size of exporting memo fields. It appears to be 255
Checking MS, I found this  http://support.microsoft.com/kb/208801/en-us although its excel, I assume SendObject to be same logic as exporting

All I can suggest is to read via a recordset, see if it makes a difference
u may need to define your string

dim x as string * 2000

or something along those line
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.