通過Outlook發送之前如何檢查收件人地址？

在某些時候，您可能會錯過通過Outlook發送電子郵件時將一些重要的收件人添加到“收件人”，“抄送”或“密件抄送”字段中的情況。在這裡，我可以介紹一種在通過Outlook發送之前檢查是否已添加特定電子郵件地址的方法。

使用VBA代碼發送前檢查地址

在這裡，我有兩個代碼可以幫助您解決此工作，您可以根據需要選擇任何人。

1。按 Alt + F11 k啟用 Microsoft Visual Basic for Applications 窗口。

2。雙擊 本次展望會議 Project1 窗格以打開代碼編輯器，將下面的代碼複製並粘貼到編輯器中。

VBA：發送前在“收件人”字段中檢查收件人地址

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
'UpdatebyExtendoffice20180523
Dim xAddressArr() As Variant
Dim xAddress As String
Dim xRecipient As Recipient
Dim xPrompt As String
Dim xYesNo As Integer
Dim xDictionary As Scripting.Dictionary
On Error Resume Next
Set xDictionary = New Scripting.Dictionary
xAddressArr = Array("", "", "")
For i = LBound(xAddressArr) To UBound(xAddressArr)
    xDictionary.Add xAddressArr(i), True
Next i
For Each xRecipient In Item.Recipients
    If xRecipient.Type = olTo Then
        If xDictionary.Exists(xRecipient.Address) Then xDictionary.Remove xRecipient.Address
    End If
Next
If xDictionary.Count = 0 Then GoTo L1
For i = 0 To xDictionary.Count - 1
    If xAddress = "" Then
        xAddress = xDictionary.Keys(i)
    Else
        xAddress = xAddress + "; " & xDictionary.Keys(i)
    End If
Next i
xPrompt = "You are not sending this to: " & xAddress & ". Are you sure you want to send the Mail?"
xYesNo = MsgBox(xPrompt, vbQuestion + vbYesNo, "Kutools for Outlook")
If xYesNo = vbNo Then Cancel = True
L1:
  Set xRecipient = Nothing
  Set xDictionary = Nothing
End Sub

doc在發送1之前檢查收件人地址

在代碼中，您可以更改 ("“”“”") 給您所需的真實收件人。

3.然後在 Microsoft Visual Basic for Applications 窗口中，單擊工具 > 參考。檢查 Microsoft腳本運行時 複選框 參考-Project1 對話。

4。點擊 OK 並保存代碼。

現在，如果在發送電子郵件時指定的收件人沒有出現在“收件人”字段中，則會彈出一個對話框，提醒您是否發送電子郵件。
doc在發送4之前檢查收件人地址

使用上面的代碼，它僅檢查以下位置的電子郵件地址至字段，如果您想簽入至, CC 和 BCC 字段，您可以使用以下代碼。

VBA：發送前在“收件人/抄送/密件抄送”字段中檢查收件人地址

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
'UpdatebyExtendoffice20180523
Dim xRecipients As Outlook.Recipients
Dim xRecipient As Outlook.Recipient
Dim xPos As Integer
Dim xYesNo As Integer
Dim xPrompt As String
Dim xAddress As String
On Error Resume Next
If Item.Class <> olMail Then Exit Sub
Set xRecipients = Item.Recipients
xAddress = ""
For Each xRecipient In xRecipients
    xPos = InStr(LCase(xRecipient.Address), xAddress)
    If xPos = 0 Then
        xPrompt = "You sending this to " & xAddress & ". Are you sure you want to send it?"
        xYesNo = MsgBox(xPrompt, vbYesNo + vbQuestion + 4096, "Kutools for Outlook")
        If xYesNo = vbNo Then Cancel = True
    End If
Next xRecipient
End Sub

使用此代碼，您無需檢查 Microsoft腳本運行時 複選框，只需直接保存代碼即可生效。