Overclock.net banner

Outlook Rule for Incoming Attachment to LAN

451 Views 7 Replies 3 Participants Last post by  hometoast
I'm currently using Outlook 2007 and am looking for a way to take an incoming message with an attachment and have the attachment automatically sent to a location on our LAN.

For example: We have a software application that generates an Excel report each morning. The report is sent out by email to a select PDL. A member from the PDL then takes the attached report and copies it to a LAN location for pickup by a batch script that processes daily.

I am trying to automate this process, but the macros I've used thus far have failed to work.

Thanks in advance for any help!
See less See more
1 - 8 of 8 Posts
Does it have to be sent over email? Can't you just call the network location of the Excel document created daily in the batch scrip? Or at least have a script that copies it to the dirrectory where ethe script runs?
The software application generates the excel file and does not have the ability, at least that I know of, to drop the file to a LAN location. Emailing is the only way to get the report out of the application besides manual intervention.
To the top.
You can't do it solely with Outlook rules/actions. You'll need to write a program to handle it. It's relatively trivial to do it .Net (VB or C#) using the Microsoft.Office.Interop.Outlook namespace. If you really need, shoot me a PM with some more details and I could whip something up.
I realize this needs to be set as a function within Outlook in something such as VB, but I need a rule in place first so send the files to a particular folder that I'm using within the script.
I'm saying there is no "Save attachment" action to be applied. You need to process incoming messages, when they have an attachment, then run a program.
1 - 8 of 8 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.