VBA show Windows Logged On User's Email Address

[brunopg7]

I have a MS Access 2003 application where I need the current Windows logged on user's exchange email address.

Do I need to query Active Directory to do this or is there a simpler way?
We have different domains in our organization and querying AD would be cumbersome.

Thanks,
Bruno

 

[NigelShaw]

Hi

Doug has already answered this on UA?

I'm afraid I don't think that there is a completely automated solution. In our system at work, we have SQL server and the network name and email are stored there. It's a pretty simple input process and guarantees that the network name of the user will then alway link up to the email.


Cheers


Nidge