PDA

View Full Version : Get email address of the user log from excel vba



naris
08-22-2008, 06:03 AM
I want write in cell A1 with a email address of the user who have log in the PC.

: pray2: please, could you let me know the macro to do it ? ..

Thanks,
Naris

Kenneth Hobs
08-22-2008, 07:08 AM
You can get the username. How that relates to their email address is something that you have to "lookup".

Sub Test
Range("A1").Value=Environ("username")

naris
08-23-2008, 10:49 PM
Thanks you very much

Naris