Advertisement
5_2007-2008 Microsoft Office Apps/VBA #177645

Save Outlook Mail Attachment

This code snippet is actually a Macro for Outlook 97, 98 or 2000 but can be easily instituted into VB by creating your Outlook.Application object to completely automate the mod from VB. It could also be used with MAPI mail as well.

AI

AI Summary: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.

Source Code
original-source
Sub AutomateMe()
 Dim oApp As Application
 Dim oNS As NameSpace
 Dim oMsg As Object
 Dim oAttachments As Outlook.Attachments
 Dim strControl
 
 Set oApp = New Outlook.Application
 Set oNS = oApp.GetNamespace("MAPI")
 'Set folder to check the INBOX
 Set oFolder = oNS.GetDefaultFolder(olFolderInbox)
 strControl = 0
 
 For Each oMsg In oFolder.Items
 With oMsg
'Check for new mail (unread=true)
 If .UnRead Then
'This could use the .Subject as well to search for text in the subject line.
 If InStr(1, .Body, "Body Text to look for") > 0 Then
  oMsg.Attachments.Item(1).SaveAsFile "Your Drive:\Your Path\" _
  & oMsg.Attachments.Item(1).DisplayName
'Set mailItem to read by setting UnRead flag to false.
  .UnRead = False
  Exit Sub
 End If
 End If
 End With
 Next
End Sub
Original Comments (3)
Recovered from Wayback Machine