It's hard to tell what that monster is expected to do. Could you explain in
plain text?

--
Best regards
Michael Bauer - MVP Outlook
Synchronize Outlook Categories:
http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6

Am Fri, 21 Dec 2007 22:07:54 -0800 schrieb Josh Andrews:

I am trying to create a custom field in a view. I want to use the InStr
function to scan the text of the message and find some particular
content. I've been using functions like the following:

Left(Right([Message],((Len([Message])-InStr(1,[Message],"Additional
Comments From",1)-Len("Additional Comments

From")))),InStr(Right([Message],((Len([Message])-InStr(1,[Message],"Additional
Comments From",1)-Len("Additional Comments From"))))," "))

The only problem is that the function doesn't always work like I think
it will, and a little bit of troubleshooting reveals that Outlook only
seems to look at the first 255 chars of the [message] field. The Len()
function always returns a maximum of "255" even if there is more to the
text of the message.

Is there any way to access the full text of the message in a calculated
field or am I just stuck? Or do I need to start writing forms or
full-blown plugins?

Josh