Grouping by Custom Fields


G

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])
 
Ad

Advertisements

S

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



MichaelWacey said:
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top