Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Crestview Hills, Kentucky, USA
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Identify Appointments (OL03 & Server03)

    We have a public calendar on which truck deliveries are entered. Our sales people often forget to include their sales person's name in the appointment. Is there a way to identify who placed an appointment on a public calendar?

    Thanks,
    Craig.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Identify Appointments (OL03 & Server03)

    It can be done with VBA code. From the Outlook Menu select Tools, Macro, Security, Medium. Open the appointment item. Press Alt-F11 to open the Visual Basic Editor, Then press Ctrl-G to open the Immediates Window, it should appear on the bottom right side of the VBE window. In it enter:

    ?Activeinspector.CurrentItem.Organizer

    and press return.

    You can turn this into code (which can be used on the open item or the unopened selected item in the calendar) by wrapping it as follows:

    Sub WhoOrganized()
    Dim strO As String
    If CBool(Inspectors.Count) Then
    strO = ActiveInspector.CurrentItem.Organizer
    ElseIf TypeName(ActiveWindow) = "Explorer" Then
    strO = ActiveExplorer.Selection(1).Organizer
    End If
    If CBool(Len(strO)) Then MsgBox "Event entered by: " & vbLf & strO
    End Sub

    and then attach it to your toolbar if you wish via View, Toolbars, Customize, Macros.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •