Thread: Message Field
View Single Post
  #1  
Old December 22nd 07, 07:07 AM posted to microsoft.public.outlook.program_vba
Josh Andrews
external usenet poster
 
Posts: 2
Default Message Field

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
Ads