I have a Microsoft Access Application which I'm currently working on.

We're running on a domain and I need to find the email address of the currently logged in user from Active Directory.

When using Outlook WebAccess, if I type in a member of staff's login name, eg. LFD then press "Check Names" it corrects it with their full name and email address.

Therefore I'm pretty sure the Domain Login and Email Address Associated with that person's login are held in the same place.

I need to be able to query this active directory, passing in the currently logged in username and have it return their email address.

Code:
LoggedInUser=(Environ("Username"))
is sufficient, as staff do not have access to cmd or anything that would enable the changing of this environment variable. - Plus security isn't a huge priority with the system.

I'm presuming I would need to setup a custom function to do this
I'm most happy with performing this within VBA
However I have access to VB 6, which I can build an external function, should I have to.

Please help me, as I'm struggling to find a way to do this, and it's the most essential part of my project.

any help or directions to another site are all greatfully received.


Dan Walters
danielwalters6 at hotmail dot com


Little Bit More Background Info:
With this email address, I have tried and tested a way for Access to communicate directly with the network's smtp server, and a specified email address an email confirming them of their actions whilst in the system.
I need to pass in the email address of the currently logged in user, to get my project working as I would like.