Solved

How to lookup a users email address in a Notes Application

Posted on 2010-11-17
9
775 Views
Last Modified: 2013-12-18
Writing a little app and I want to lookup a users email address from the NAB. Don't have designer access to the NAB. From memory it's either $VIMPeople or $Users that are best too lookup to and should the key (users name) be hierachical or abbreviated?

Thanks
0
Comment
Question by:Sam654
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 13

Expert Comment

by:CRAK
ID: 34162125
If you open the addressbook using CTRL + SHIFT + View > Goto, you can access the views. I have always preferred "($Users)" over "($VIMPeople)" as it contains a number of name.
Mind that you can always create a local copy (without ACL) of the NAB to checkout the design, or use (a copy of) the template for that purpose!

Another approach is the use of @MailDbName, or notesRegistration.GetUserInfo(). It's best to check designer help on the latter!
0
 
LVL 22

Expert Comment

by:mbonaci
ID: 34162205
You can use the LS function (that gets user's document from NAB) from my comment here:

http://www.e-e.com/Q_25581063.html
0
 
LVL 22

Expert Comment

by:Bill-Hanson
ID: 34163954
I prefer using ($Users) since you can look-up by first name, last name, email address, full name, short name, abbreviated name, or common name.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Author Comment

by:Sam654
ID: 34184507
If I was to use the formula @MailDbName to get the users mail file, how could I then get the users email address?
0
 
LVL 22

Accepted Solution

by:
Bill-Hanson earned 500 total points
ID: 34187822
@MailDbName returns info about the user's mail database, but the Domino Directory.

Luckily, there's a handy @formula that performs look-ups to the Directory automatically...

    @NameLookup([ForceUpdate];@UserName;"InternetAddress")
0
 
LVL 22

Expert Comment

by:Bill-Hanson
ID: 34187830
Sorry... That should have been "info about the user's mail database, NOT the Domino Directory".
0
 
LVL 22

Expert Comment

by:mbonaci
ID: 34188148
The connection between mail db and e-mail is the user document in Name and Address book (names.nsf).
Since you're using @MailDbName, which gets the mail db of the currently logged-in user, I suggest you use the function I mentioned, cuz' it gets currently logged-in user's document in NAB.

Then get the e-mail from the document it returns, as it is explained bellow the function.

Nevertheless, if you have additional questions, ask...
0
 
LVL 22

Expert Comment

by:mbonaci
ID: 34188167
Ups, I haven't seen those last three comments before posting.
So, yes, if you're using only formulas, that is simpler way to go.
0
 
LVL 7

Author Closing Comment

by:Sam654
ID: 34193240
Nice, didn't know about that @Function and like it. Unfortunalty I'm not able to use it and have opened another question detailing why etc. Will be using Lotus Script for this next bit. Link to new question below.

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_26632680.html

0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question