Solved

Rule to autosave attachment in Outlook

Posted on 2004-09-17
9
10,246 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 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
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 is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 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