Solved

Rule to autosave attachment in Outlook

Posted on 2004-09-17
9
10,198 Views
Last Modified: 2012-06-22
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
Comment
Question by:Macros
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 15

Assisted Solution

by:will_scarlet7
will_scarlet7 earned 150 total points
ID: 12087145
You could program your own "rule" in VBA. Below is a link that gives basics for this:

http://support.microsoft.com/?kbid=235852
0
 
LVL 13

Accepted Solution

by:
stefri earned 250 total points
ID: 12115975
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
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12122930
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
 
LVL 13

Expert Comment

by:stefri
ID: 12125765
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 2

Author Comment

by:Macros
ID: 12140892
Increasing to 400 to split points between the answers.
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12140938
ThanX Macros! Glad we could be a help.

God bless!

Sam
0
 
LVL 2

Author Comment

by:Macros
ID: 12140975
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
 

Expert Comment

by:LMNowak
ID: 13928872
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
 
LVL 13

Expert Comment

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

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now