I am trying to run some VBA code to automatically save attachments based on a phrase in the attachment name to specific folders on my desktop.
Public Sub saveAttachtoDisk(itm As Outlook.MailItem)
Dim objAtt As Outlook.Attachment
Dim saveFolder As String
For Each objAtt In itm.Attachments
If objAtt.SaveAsFile = "Test1" Then
saveFolder = "P:\Desktop\Reports\Test1"
If objAtt.SaveAsFile = "Test2" Then
saveFolder = "P:\Desktop\Reports\Test2"
If objAtt.SaveAsFile = "Test3" Then
saveFolder = "P:\Desktop\Reports\Test3"
If objAtt.SaveAsFile = "Test4" Then
saveFolder = "P:\Desktop\Reports\Test4"
If objAtt.SaveAsFile = "Test5" Then
saveFolder = "P:\Desktop\Reports\Test5"
objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName
Set objAtt = Nothing
Next
End Sub
It is probably more long winded then it needs to be, but I am hoping you get the idea of what I am trying to do.
I am a complete VBA novice so any help would be appreciated
Aucun commentaire:
Enregistrer un commentaire