Outlook profile info is not accessable using the Outlook Object
Model, but using CDO it is possible (without incurring any security popups!).
VB Code:
  1. Option Explicit
  2. 'Add a reference to Microsoft CDO 1.21 Type Library
  3. 'If you do not have it installed on your system you can install it
  4. 'from your Office CD.
  5. 'Also, Outlook needs to be running first!!!
  6. Private Function GetCurrentProfileName() As String
  7.  
  8.     Dim oSession As MAPI.Session
  9.    
  10.     Set oSession = CreateObject("MAPI.Session")
  11.     oSession.Logon "", "", False, False
  12.     GetCurrentProfileName = oSession.Name
  13.     oSession.Logoff
  14.     Set oSession = Nothing
  15.  
  16. End Function
  17.  
  18. Private Sub Form_Load()
  19.     MsgBox "Current Outlook Profile = " & GetCurrentProfileName, vbOkOnly + vbInformation
  20. End Sub