?
Solved

Rule to autosave attachment in Outlook

Posted on 2004-09-17
9
Medium Priority
?
10,260 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 15

Assisted Solution

by:will_scarlet7
will_scarlet7 earned 600 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 1000 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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
 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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: …
Suggested Courses

765 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