Link to home
Start Free TrialLog in
Avatar of Bes4dmin
Bes4dminFlag for Sweden

asked on

show e-mail address instead of name

Hi I'm running Lotus Notes 8.5.1 standard and want to see the e-mail addresses of the senders instead of their name in my inbox.
I want this especially if they are external addresses. Is this possible in Notes?

Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

I think you need the Designer client for that. You have to modify the lay-out of the Inbox folder.
Avatar of Bes4dmin

ASKER

ok, and how do I do that?
Heh :-)

If you have Domino Designer experience, it's a piece of cake. If you don't, it's a long story. Plus, you have to be aware of the fact that you might have to redo your modifications when upgrades of the server or client are installed.

The long story is in fact a Developer Training. Basically:
- you open the database in the Designer
- you open the Folders view
- you open the Inbox folder
- you modify the sender column, so that it uses the field From (it contains the entire name + internet address)
- you save the folder
- you reopen the mail database

Required permission in your mail database is Designer (see the Access Control List). If you're only Editor, ask your Administrator.
Ok I see, so do I need to open the actual database .nsf file or the template ntf? Cause I'm trying to open my mail.nsf and nothing happen in designer, nothing loads up.
I've tried opening both my live mail database on the server and the replica I have locally. And I'm Manager of the database. Any suggestions?
Open the database in the Notes client, then click View/Design (or View/Agents). Normally, the Designer loads and you can see all design elements of the database (if you are Manager).
Alright, I have opened the database but I'm not following the part about modifying the sender column. This is how it looks like. What do I need to modify?
 
ScreenHunter-01-Feb.-17-11.22.gif
Strange... I don't have a Sender column in the Inbox folder... I suppose it is either an older template, or you already modified it, based on earlier modifications or so.

Anyway... you have to change one line:
      CN1 := @Trim(@Name([CN]; Who));
into
      CN1 := @Trim(@Name([ADDRESS821]; Who));

No harm done, you can always change the code back.
Thanx for the reply but that didn't do it. When I changed to ADDRESS821 the sender column in Notes got blanc, empty. And I do have fefault settings I haven't change anything. I'm using Notes Designer Admin 8.5.1
and the template on the server is 8.x.x something I believe.

Here's the original code:

SentBy := @If(Principal = ""; From; Principal);
Who := @If(DeliveredDate != "" | SendTo = ""; SentBy; @Subset(SendTo; 1));
CN1 := @Trim(@Name([CN]; Who));
CN2 := @Left(@Right(Who;"/DDA:");"/" );
CN := @If(@Contains(Who;"/DDA:");CN2;@Contains(@Right(Who;"@");">") & CN1="";@Trim(Who);CN1);
G := @If(CN = ""; @Trim(@If(DeliveredDate != "" | SendTo = ""; @Name([G]; SentBy); @Name([G]; @Subset(SendTo; 1)))); "");
S := @If(CN = ""; @Trim(@If(DeliveredDate != "" | SendTo = ""; @Name([S]; SentBy); @Name([S]; @Subset(SendTo; 1)))); "");
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);
@If(Form = "Delivery Report" : "NonDelivery Report" : "Trace Report" : "Quota Report"; "Mail Router"; Person2)

When I make the modification, it shows only the mail address...

By the way: you can modify the column's code and then click the refresh-icon that shows up (in the upper-left corner of the code frame), to see the results in the Designer.

Otherwise, can you please post the code of the column, like I did? I think there's more code below the last line in the screenshot you already supplied.
yeah that's strange, if you take a look at the screenshot I provided at the beginning, I have two Sender Columns, what's that about? They have different code, I don't know if that has to do anything with this..but anyway here's the code

SentBy := @If(Principal = ""; From; Principal);
Who := @If(DeliveredDate != "" | SendTo = ""; SentBy; @Subset(SendTo; 1));
CN1 := @Trim(@Name([CN]; Who));
CN2 := @Left(@Right(Who;"/DDA:");"/" );
CN := @If(@Contains(Who;"/DDA:");CN2;@Contains(@Right(Who;"@");">") & CN1="";@Trim(Who);CN1);
G := @If(CN = ""; @Trim(@If(DeliveredDate != "" | SendTo = ""; @Name([G]; SentBy); @Name([G]; @Subset(SendTo; 1)))); "");
S := @If(CN = ""; @Trim(@If(DeliveredDate != "" | SendTo = ""; @Name([S]; SentBy); @Name([S]; @Subset(SendTo; 1)))); "");
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);
@If(Form = "Delivery Report" : "NonDelivery Report" : "Trace Report" : "Quota Report"; "Mail Router"; Person2)

Open in new window

But that's the code I sent you earlier! Then where did you get the code that's displayed in the image??

Anyway, in the code above, if you replace CN by ADDRESS821 on line 3, it should work (it did for me).
Nop, it does not work for me. The Sender field just get empty instead.
ASKER CERTIFIED SOLUTION
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I will test that
Sweet, that did it. It works now. I'm seing external senders by their e-mail address and internal senders by their name, exactly what I was after. Thank you sjef bosman for the help! Much appreciated!
just nailed it!