SendObject -- Message Text Truncates

Posted on 2006-04-05
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
    LVL 44

    Expert Comment

    by:Leigh Purvis
    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

    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
    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

    I think the export functionality has limits on the size of exporting memo fields. It appears to be 255
    Checking MS, I found this 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 Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now