如何追踪共享Outlook邮箱中用户添加或删除分类的操作？

Absolutely, you can track when local users add or remove categories on your shared (ABC) mailbox using Outlook VBA, C# code, or an Outlook add-in. Each approach has its own use cases—let’s walk through them with actionable steps and examples:

This is a quick, no-installation option if you need to prototype or roll out a lightweight solution to users. You’ll need to deploy the macro to each user’s Outlook (since VBA runs locally per instance):

• Step 1: Access the shared mailbox folder
  First, make sure the shared mailbox is added to the user’s Outlook profile. Then, in the VBA editor (press Alt+F11), reference the shared mailbox’s target folder like this:

  Dim sharedInbox As Folder
  Set sharedInbox = Application.Session.Folders("(ABC)").Folders("Inbox")
  

• Step 2: Listen for item changes
  Use the ItemChange event on the shared folder—this triggers whenever an email’s categories are added or removed. Store the original category value to compare against the new one:

  Private WithEvents sharedItems As Items
  
  Private Sub Application_Startup()
      ' Link the listener to the shared inbox when Outlook starts
      Set sharedItems = Application.Session.Folders("(ABC)").Folders("Inbox").Items
  End Sub
  
  Private Sub sharedItems_ItemChange(ByVal Item As Object)
      Static originalCategories As String
      Dim currentCategories As String
      
      If TypeOf Item Is MailItem Then
          currentCategories = Item.Categories
          
          ' Log only if categories changed from the original state
          If originalCategories <> "" And originalCategories <> currentCategories Then
              Dim logFile As Integer
              logFile = FreeFile
              Open Environ("USERPROFILE") & "\OutlookCategoryChanges.log" For Append As #logFile
              Print #logFile, Now() & " | User: " & Environ("USERNAME") & " | Email Subject: " & Item.Subject & " | Old Categories: " & originalCategories & " | New Categories: " & currentCategories
              Close #logFile
          End If
          
          ' Update original value for next check
          originalCategories = currentCategories
      End If
  End Sub
  

• Limitations: Users need to enable macros in Outlook, and the macro only runs when their Outlook is open. You’ll have to distribute this to all 100 users manually or via group policy.

C# offers more flexibility—you can build a standalone app, background service, or integrate with your existing Excel rule system. Two common approaches:

Option 1: Use Outlook Interop #

Similar to VBA, but runs as a separate process. Requires Outlook to be installed on the machine:

using Microsoft.Office.Interop.Outlook;
using System;

class CategoryTracker
{
    private Items sharedInboxItems;
    private string lastCategories;

    public void StartTracking()
    {
        Application outlookApp = new Application();
        NameSpace outlookNamespace = outlookApp.GetNamespace("MAPI");
        Folder sharedInbox = outlookNamespace.Folders["(ABC)"].Folders["Inbox"] as Folder;
        sharedInboxItems = sharedInbox.Items;
        sharedInboxItems.ItemChange += SharedInboxItems_ItemChange;
    }

    private void SharedInboxItems_ItemChange(object Item)
    {
        if (Item is MailItem mail)
        {
            string currentCategories = mail.Categories;
            if (!string.IsNullOrEmpty(lastCategories) && lastCategories != currentCategories)
            {
                // Log to your preferred destination (database, Excel, etc.)
                string logEntry = $"{DateTime.Now} | User: {Environment.UserName} | Subject: {mail.Subject} | Old: {lastCategories} | New: {currentCategories}";
                System.IO.File.AppendAllText(@"C:\CategoryTracking\Changes.log", logEntry + Environment.NewLine);
            }
            lastCategories = currentCategories;
        }
    }
}

Option 2: Use Exchange Web Services (EWS) #

This approach doesn’t require Outlook to be installed—run it on your central system that manages the Excel rules. You’ll need to authenticate with Exchange and subscribe to push notifications for the shared mailbox:

• Use the Microsoft.Exchange.WebServices.Data NuGet package.
• Create a subscription to monitor item changes in the shared mailbox’s folder.
• When a change is detected, fetch the mail item’s categories and compare against a stored original value (save system-assigned categories in a custom mail property when your Excel rule runs).

For enterprise-wide deployment, a VSTO (Visual Studio Tools for Office) add-in is the most robust option. It integrates directly with Outlook, runs automatically on startup, and can be deployed to all users via MSI or Office 365:

• Key Benefits:

  • Auto-loads for all users with the shared mailbox added.
  • Supports custom UI elements (e.g., a tracking dashboard) if needed.
  • Enables centralized logging (send change data to your server instead of local files).
  • Easier to maintain and update across 100 users.

• Core Logic:
  In the add-in’s ThisAddIn_Startup event, hook into the shared mailbox folder’s ItemChange event just like in VBA/C#. Use Outlook’s custom properties to store system-assigned categories, making it easy to distinguish user modifications from system updates.

• Distinguish System vs. User Changes: When your Excel rule assigns categories, add a custom property (e.g., SystemAssignedCategories) to the mail item with the original value. Compare this to the current Categories to confirm user-initiated changes.
• Permissions: Ensure the tracking process has read/write access to the shared mailbox and your logging destination (file, database, etc.).
• Performance: For high-traffic mailboxes, avoid heavy processing in the ItemChange event—offload logging to a background thread if needed.

内容的提问来源于stack exchange，提问作者Hitesh the learner