• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

Set up a view in my inbox grouping mails from the same person(s)

I wan't to set up a vew which groups the mails under each senders name.
Something like I've tried to illustrate below

  *   >Jane Doe
          vJohn Doe
                John Doe      Subject 1
  *            John Doe      Subject 2
0
fstran
Asked:
fstran
  • 2
2 Solutions
 
qwaleteeCommented:
You need the Designer version of Notes.

Make a copy of All Documents.  Change the WHO column properties.  The second tab alows sorting -- change it from STANDARD to CATGEORIZEd.  That's it.
0
 
HemanthaKumarCommented:
In the mail db there is a view which already groups by person.

It gives information like this

*   >Jane Doe
          vJohn Doe
                Date/Time Recd      Subject 1
  *            Date/Time Recd      Subject 2

If you don't have one then it is easy to create one

View's Selection Formula would be
SELECT  @IsNotMember("A";ExcludeFromView)

The first col where you want the user to be listed make it a categorized column with foll formula

SentBy := @If(Principal = ""; From; Principal);
Attendees := @Trim(RequiredAttendees : OptionalAttendees);
Who := @If(DeliveredDate != ""; SentBy; @Elements(Attendees) > 0; @Subset(Attendees; 1); SendTo = ""; SentBy; @Subset(SendTo; 1));
CN1 := @Trim(@Name([CN]; Who));
CN := @If(@Contains(@Right(Who;"@");">") & CN1="";@Trim(Who);CN1);
G := @If(CN = ""; @Trim(@Name([G]; Who)); "");
S := @If(CN = ""; @Trim(@Name([S]; Who)); "");
Person := @If(CN != ""; CN; G != ""; G + " " + S; S != ""; S; @Trim(X400FreeForm));
Person2 := @If(@Left(Person;1)="\"" & @Right(Person;1)="\""; @LeftBack(@RightBack(Person;1);1); Person);
FullName := @If(Form = "Delivery Report" : "NonDelivery Report" : "Trace Report"; "Mail Router"; Person2);
@If(
    @Word(FullName; " "; 4) != "" & @Length(@Word(FullName; " "; 3)) > 1 ;
  @Word(FullName; " "; 4)   + " " + @Word(FullName; " "; 2) + " " +@Word(FullName; " ";3)+ ", "+ @Word(FullName; " "; 1);

   @Word(FullName; " "; 3) != "" & @Length(@Word(FullName; " "; 2)) = 1 ;
        @Word(FullName; " "; 3) + ", " + @Word(FullName; " "; 1) + " " + @Word(FullName; " "; 2);

   @Word(FullName; " "; 3) != "" & @Contains(@Word(FullName; " "; 2);".") = 0 ;
        @Word(FullName; " "; 2) + " " + @Word(FullName; " "; 3) + ", " + @Word(FullName; " "; 1);

   @Word(FullName; " "; 3) != "" & @Contains(@Word(FullName; " "; 2);".") ;
        @Word(FullName; " "; 3) + ", " + @Word(FullName; " "; 1) + " " + @Word(FullName; " "; 2);

    @Word(FullName; " "; 2) != ""; @Word(FullName; " "; 2) + ", " + @Word(FullName; " "; 1); @Word(FullName; " "; 1)
)

And Subject column will be of this formula

@If(Form = "NonDelivery Report"; "DELIVERY FAILURE: " + FailureReason; Form = "Delivery Report"; "DELIVERED: " + Subject; Form = "Return Receipt"; "RECEIVED: " + Subject; Form = "ReturnNonReceipt"; "NOT RECEIVED: " + Subject; Subject)

~Hemanth
0
 
qwaleteeCommented:
HemanthaKumar,
Which view groups by person?  Maybe in your custom mail DB.

The very short solution I provided above will allow the user to easily create such a view in about 2 minutes, assuming Designer is available.

If not, I'll have to mail some code out.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now