• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10283
  • Last Modified:

Rule to autosave attachment in Outlook

I don't know if this is even possible. Our Helpdesk get in 14 mails daily which have attachments that need to be saved out to a shared area for some other departments. Is it possible to set up a rule (based on sender and subject) that will save out the attachments from these mails automatically to a particular area?

[Edit - should mention we use Outlook 2002 in an Exchange 5.5 environment.]

Steve
0
Macros
Asked:
Macros
  • 3
  • 3
  • 2
  • +1
2 Solutions
 
will_scarlet7Commented:
You could program your own "rule" in VBA. Below is a link that gives basics for this:

http://support.microsoft.com/?kbid=235852
0
 
stefriCommented:
Open VBA (Alt F11)
cut qnd pqste the code below
' ----- Adjust the value of saveFolder to whatever you want -------

Public Sub saveAttachtoDisk (itm As Outlook.MailItem)

Dim objAtt As Outlook.Attachment

Dim saveFolder As String
saveFolder = "c:\temp\"

    For Each objAtt In itm.Attachments
        objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName
        Set objAtt = Nothing
    Next
End Sub

Create a rule
check mail when they arrive
with specific words in the subject
run a script
select saveAttachtoDisk from the available macros
stop processing more rules
Enjoy
Stefri
0
 
will_scarlet7Commented:
Steve,
If you need help implementing either of these methods, please post your comments here and Stefri &/or I can help.

God bless!

Sam
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
stefriCommented:
I forget to mention that:
1) Set Tools/Macros/Security to Medium
2)Close Outlook:  save the project when asked
3) Restart outlook: accept the Enable Macro Warning to get the macro fired

Stefri
0
 
MacrosAuthor Commented:
Increasing to 400 to split points between the answers.
0
 
will_scarlet7Commented:
ThanX Macros! Glad we could be a help.

God bless!

Sam
0
 
MacrosAuthor Commented:
The script from stefri works fine (client based but chat you gonna do). The link from will is useful but I'm no VBS expert so I gave stefri the bulk of the points.

thanks guys.
0
 
LMNowakCommented:
The following response was given by one of your analysts to a question that was asked about autosaving outlook attachments from specific people on arrival:

'Open VBA (Alt F11)
cut qnd pqste the code below
' ----- Adjust the value of saveFolder to whatever you want -------

Public Sub saveAttachtoDisk (itm As Outlook.MailItem)

Dim objAtt As Outlook.Attachment

Dim saveFolder As String
saveFolder = "c:\temp\"

    For Each objAtt In itm.Attachments
        objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName
        Set objAtt = Nothing
    Next
End Sub

Create a rule
check mail when they arrive
with specific words in the subject
run a script
select saveAttachtoDisk from the available macros
stop processing more rules
Enjoy
Stefri'

I understand how to create the rules and how to create the sub in VBA, but I don't know how to relate the two.  The above suggestion indicates that there is a 'run a script' option in the rules menu, but I don't see it.  Please adivse.


0
 
stefriCommented:
ol2002 and more has the 'Run a script' option in rule wizard
stefri
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now