Ever forget to send an attachment to someone?  The following code will search your outgoing message text for the word "attach."  You can add as many words as you want.  The code needs to go in the ThisOutlookSession module in Outlook VBA; make sure macro security is not set to High.
Private Sub Application_ItemSend(ByVal Item as Object, Cancel as Boolean)
   If Instr(1, Item.Body, "attach", vbTextCompare) > 0 Then
      If Item.Attachments.Count = 0 Then 
          MsgBox "You forgot the attachment."
          Cancel = True 
      End If 
   End If 
End Sub
For more examples of VBA using Outlook, check out Sue Mosher's site OutlookCode.
Subscribe to:
Post Comments (Atom)
 
 
 Atom Feed (xml)
 Atom Feed (xml)
1 comment:
Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!
Post a Comment