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.