Outlookmakros und -skripte

WarnIfnoAttach.otm
'durchsuche zu sendende Mails nach den Schlüsselwörtern und warne vor dem absenden, wenn vorhanden aber kein Anhang ausgewählt
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim retMB As Variant
Dim strBody As String
Dim iIndex As Long
Dim findArr As Variant
 
'hier die Suchbegriffe eingeben:
findArr = Split("attach,anhang,anbei,datei,file,xlsx,docx", ",")
 
On Error GoTo handleError
 
For i = 0 To UBound(findArr)
 
iIndex = InStr(UCase(Item.Body), UCase(CStr(findArr(i))))
 
    If iIndex > 0 And Item.Attachments.Count = 0 Then
 
        retMB = MsgBox("You may have forgotten to attach a file." & vbCrLf & vbCrLf & "Do you still want to continue?", vbQuestion + vbYesNo + vbMsgBoxSetForeground)
            If retMB = vbNo Then Cancel = True
            End If
 
Next
 
handleError:
 
 If Err.Number <> 0 Then
    MsgBox "Outlook Attachment Alert Error: " & Err.Description, vbExclamation, "Outlook Attachment Alertr Error"
 End If
 
End Sub