Currently logged in user's email

[John]

Hi

We can get the current logged in user's name but is it also possible to get
the default email form outlook of the currently logged-in user as well? The
reason for this is that I need to email the users warnings from time to
time. As the system may be running by different users on different pcs, I
need to pick up the email of the currently logged-in user to send him/her
the email.

Thanks

Regards

 

[Arvin Meyer [MVP]]

I don't see any mention of an Outlook newsgroup in the list of newsgroups
you asked this in. Your question may be better answered in a newsgroup
appropriate to your problem. This newsgroup is dedicated to the Microsoft
Access database product.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[John]

Well the app is in access so I was wondering how to do it in access. In
outlook I can get the address using Application.Session.CurrentUser.Address.

Regards

 

[John Vinson]

Hi

We can get the current logged in user's name but is it also possible to get
the default email form outlook of the currently logged-in user as well? The
reason for this is that I need to email the users warnings from time to
time. As the system may be running by different users on different pcs, I
need to pick up the email of the currently logged-in user to send him/her
the email.

Thanks

Regards

You're asking in three wrong places. Microsoft Access(TM) is a
database program in the Office Pro suite; your question seems to be
related to a differetn program, Microsoft Outlook.

Please try microsoft.public.outlook.general or one of the groups
related to it.

John W. Vinson[MVP]

 

[John Vinson]

Well the app is in access so I was wondering how to do it in access. In
outlook I can get the address using Application.Session.CurrentUser.Address.

Oh... sorry! Had the telepathy interface turned off... <g>


John W. Vinson[MVP]

 

[Tom Wickerath]

Very likely not. This ability was patched a long time ago by Microsoft, to
prevent clever virus writers from accessing any e-mail addresses stored in
Outlook or Outlook Express.

However, it is very easy to provide real-time requests or other information
to your users from within Access itself. You simply use a hidden form that
includes a timer event. Set it for something like 300000 milliseconds (5
minutes) to poll a boolean field (call it blnNotify) in a table in the shared
BE database. As the Administrator, you can toggle this value, and add
whatever text you want to another field (call it msgText, for example). Every
5 minutes, your hidden form interrogates the value of blnNotify. If it equals
true, display the hidden form in modal mode. Include an OK or close button
that takes the correct course of action, which might include simply re-hiding
the form (and not re-opening after it has been viewed once) or closing the
database so that you can perform maintenance on the BE.

I have a sample that I can send to you, if you wish to purse this further.
If you are interested, send me a private e-mail message with a valid reply-to
address. My e-mail address is available at the bottom of the contributor's
page indicated below.

Please do not post your e-mail address (or mine) to a newsgroup reply. Doing
so will only attract the unwanted attention of spammers.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Arvin Meyer [MVP]]

You can get the Windows user from an api:

http://www.mvps.org/access/api/api0008.htm

I think you need to find who is logged into the current profile in Outlook
from within Outlook.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access