Macros
asked on
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
[Edit - should mention we use Outlook 2002 in an Exchange 5.5 environment.]
Steve
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Increasing to 400 to split points between the answers.
ThanX Macros! Glad we could be a help.
God bless!
Sam
God bless!
Sam
ASKER
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.
thanks guys.
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.
'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.
ol2002 and more has the 'Run a script' option in rule wizard
stefri
stefri
If you need help implementing either of these methods, please post your comments here and Stefri &/or I can help.
God bless!
Sam