ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Capturing Email Address (https://www.excelbanter.com/excel-programming/374696-capturing-email-address.html)

Bret

Capturing Email Address
 
Please, is there away in VBA code to capture the current users email address.
All employees in our company use Outlook exclusively.

thank you.

Ron de Bruin

Capturing Email Address
 
Hi Bret

Not so easy but Randy have code on his site to do this
http://vbnet.mvps.org/

look for
Visual Basic Registry Routines
RegQueryValueEx: Retrieve Email Account Info (Outlook)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bret" wrote in message ...
Please, is there away in VBA code to capture the current users email address.
All employees in our company use Outlook exclusively.

thank you.





All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com