Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SendObject -- Message Text Truncates

Posted on 2006-04-05
Medium Priority
Last Modified: 2008-02-01
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.

Question by:mixxie
  • 2
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16385558
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).

Author Comment

ID: 16385704
There's not really any code, since I'm using the macro, but here it is anyway:

Issues Form Macros
cmdEmailUser : On Click
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)

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.
LVL 44

Expert Comment

by:Leigh Purvis
ID: 16386128
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).
LVL 65

Accepted Solution

rockiroads earned 2000 total points
ID: 16386180
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question