Retrieve user's email

I would like to retrieve the current notes user’s email address for references but the following code give me no response.

@Prompt([ok]; “email add”; @Name([ADDRESS821]; @Username(0)));

am i going on a wrong direction here.

i have initially use @DbLookup but i cant seem to get the right parameter to fill in.

Subject: Retrieve user’s email

Try this one, it is ok according to my testing:

@Prompt([Ok];“”;@Text(@DbLookup(“”:“NoCache”;“ServerName”:“NAMES.NSF”; “People”;@Name([cn];@username);5)))

Subject: RE: Retrieve user’s email

cheers

the output of ur code is username, i am looking for email address.

Subject: RE: Retrieve user’s email

Really?

pls check your name.nsf, the “people” view, E-mail column is 5th. My code turns out to be email address of current user.

Subject: RE: Retrieve user’s email

appreciate ur reply. i did check on my view and it show otherwise. which is weird.

but i change the view to $Users and get it from there. According to Domino Administrator (edit person details) the value i get from it the people’s Internet Address.

anyway i will live with it for now until i find out the best solution.

Subject: Retrieve user’s email

Have you tried:@NameLookup( [ Exhaustive] ; @username; “MailAddress” ) ?

Erwin

Subject: RE: Retrieve user’s email

yes i have tried tht as well but it didnt return any result. i am a bit surprise bout this as well.