How to get actual address from username

Hi

I need to obtain the email address from my username, issit possible to use LotusScript to obtain it?

for example :

I’m trying to send an automated email by filling in fields and clicking on a button to send - the email body requires to have my email within.

Tried Session.Username and it gives me my username “Yuhui Shen”. Is there a function/way to get my email “yuhui@sss.xxx.ccc” ?

Thanks alot for any help

Subject: Evaluate?

You could use the Evaluate function…Something like this :

Dim v As Variant

Dim emailaddress As String

v = Evaluate(|@NameLookup([NoUpdate]; “| & Session.Username & |”; “InternetAddress”)|)

emailaddress = v(Lbound(v))

Subject: Thank you! Have question about Sections…

Thank you very much!

I have another query… issit possible to open and close individual sections via a button click? (via lotusscript or evaluate)

I would like to have certain sections open when the user clicks on 1 button, and have only other sections open when the user clicks on the other button.

Either that, or have all the other sections closed when i click to open 1 section.

Thanks!

Subject: Sections

No, I don’t think so.

Subject: Section or table

Hi,

I don’t know if there is a way to “play” with sections, but if you create a table, which always show only one row, than it can be usefull. You can try the “User pick row via caption”. When you create the table you should add as many row as many section you have and only one column.

I hope this will help you.

Regards, Attila

Subject: Tables work great

Thank you!

Seems like this is just what I need.

=)