Grouping by Custom Fields

[MichaelWacey]

I am a member of a number of Yahoo Groups. I have the messages emailed to me. Each subject line has the Yahoo group name inside [] characters. Unfortunatly, the Re: is sometimes before, sometimes after and sometimes on both sides fo the [] charaters. For example:

[Railroad] How do trains work?
Re: [Railroad] How do trains work?
Re: [Railroad] Re: How do trains work?
[Railroad] Re: How do trains work?

The conversation do not get set up correctly in Outlook. this is because Oulook expects the Re; to be at the begining. I created a custom field in a view that Removes the group name and any extra Re:. However, Outlook will not let me group on this field - it does not show up in the Group By list. If I right click on the column in a view, the Group By is greyed out.

Any thoughts?

The formula I created is:

IIf(Left([Conversation],1)="[",IIf(InStr(1,[Conversation],":"),Mid([Conversation],InStr(1,[Conversation],":")+1,Len([Conversation])),Mid([Conversation],InStr(1,[Conversation],"]")+1,Len([Conversation]))),[Conversation])

[Sue Mosher [MVP]]

Outlook does not permit grouping on formula fields. A possible workaround
would be to use VBA code to set the custom field value on each incoming
message.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"MichaelWacey" <anon...@discussions.microsoft.com> wrote in message
news:8D421025-E76B-46CA...@microsoft.com...