Grouping by Custom Fields

[Guest]

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

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([Conversa
tion],InStr(1,[Conversation],":")+1,Len([Conversation])),Mid([Conversation],
InStr(1,[Conversation],"]")+1,Len([Conversation]))),[Conversation])