Avatar of Bes4dmin
Bes4dmin
Flag 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?

Lotus IBM

Avatar of undefined
Last Comment
Sjef Bosman

8/22/2022 - Mon
Sjef Bosman

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

ASKER
ok, and how do I do that?
Sjef Bosman

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Bes4dmin

ASKER
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?
Sjef Bosman

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).
Bes4dmin

ASKER
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Sjef Bosman

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.
Bes4dmin

ASKER
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.

Sjef Bosman

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Bes4dmin

ASKER
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

Sjef Bosman

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).
Bes4dmin

ASKER
Nop, it does not work for me. The Sender field just get empty instead.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Sjef Bosman

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Bes4dmin

ASKER
I will test that
Bes4dmin

ASKER
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!
Bes4dmin

ASKER
just nailed it!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Sjef Bosman

:-))