如何在Outlook中發送郵件時自動建立任務？

Author: Siluvia Last Modified: 2025-08-06

有時候，您可能需要在Outlook中發送郵件時自動建立該郵件的任務。在此我們為您提供了一種快速實現此功能的方法。

使用VBA在Outlook中發送郵件時自動建立任務

使用以下VBA代碼，您可以根據Outlook中的發送郵件自動建立任務。請按照以下步驟操作。

1. 啟動您的Outlook，按「Alt」+「F11」打開「Microsoft Visual Basic for Applications」窗口。

2. 在「Microsoft Visual Basic for Applications」窗口中，將以下VBA代碼複製到「ThisOutlookSession」代碼窗口中。

VBA代碼：在Outlook中發送郵件時自動建立任務

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
'Updated by Extendoffice 20181123
    Dim xYesNo As Integer
    Dim xPrompt As String
    Dim xTaskItem As TaskItem
    Dim xRecipient As String
    On Error Resume Next
    xPrompt = "Do you want to create a task for this message?"
    xYesNo = MsgBox(xPrompt, vbYesNo + vbInformation, "Kutools for Outlook")
    Cancel = False
    If xYesNo = vbNo Then Exit Sub
    Set xTaskItem = Application.CreateItem(olTaskItem)
    For Each Rcp In Item.Recipients
        If xRecipient = "" Then
            xRecipient = Rcp.Address
        Else
            xRecipient = xRecipient & vbCrLf & Rcp.Address
        End If
    Next Rcp
    xRecipient = xRecipient & vbCrLf & Item.Body
    With xTaskItem
        .Subject = Item.Subject
        .StartDate = Item.ReceivedTime
        .DueDate = Date + 3 + CDate("9:00:00 AM")
        .ReminderSet = True
        .ReminderTime = Date + 2 + CDate("9:00:00 AM")
        .Body = xRecipient
        .Save
    End With
    Set xTaskItem = Nothing
End Sub