Solved

use outlook rules to send message to network location

Posted on 2011-02-15
6
373 Views
Last Modified: 2012-06-21
outlook 2007 or outlook 2010
looking to create a rule which sends a message to a mapped drive OR unc path

in the screenshot below you see what rules i can apply to a message

 screenshot
how can i achieve this?  ...what about using the "run a script" action?
what sort of script is required?  thanks for your help.
0
Comment
Question by:sknoll84
  • 3
  • 3
6 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 34897994
Run script IS the way and something like:

Chris
Sub saveMailandAttach(mai As MailItem)
Dim dosFolderPath As String
Dim intIncrement As Integer
Dim fn As String
Dim ft As String
Dim FSO As Object
Dim Subject As String
Dim del As Variant

    dosFolderPath = "c:\deleteme\"
    If Right(dosFolderPath, 1) <> "\" Then dosFolderPath = dosFolderPath & "\"
    Set FSO = CreateObject("scripting.filesystemobject")
    Subject = Left(Replace(mai.Subject, """", " "), 20) & " " & mai.ReceivedTime
    For Each del In Array("/", ":", "*", "?", "<", ">", "|")
        Subject = Replace(Subject, del, " ")
    Next
    mai.saveas dosFolderPath & Subject & ".msg", olMsg

Set FSO = Nothing
End Sub

Open in new window

0
 

Author Comment

by:sknoll84
ID: 34898018
is that all it takes?  is it flaky?  reliable?  do you use this....?
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 34898120
Is that all it takes, yes
Is it flakey ... might be if you're receiving hundreds of emails at a time
DO I use it ... yup in many permutations deleting attachments, saving attachments as well and the like.

Chris
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:sknoll84
ID: 34898451
added the developer tab to my outlook 2010

what do i do next?  open visual basic?  then what?

i'm not having much success.

thanks!
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 34898600
Insert a normal code module and paste the code there.

Call it from the rule.

Macro settings - enable macros

Chris
0
 

Author Closing Comment

by:sknoll84
ID: 34898705
pow!  thanks for your help
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This video discusses moving either the default database or any database to a new volume.

749 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