Outlook Rule for Incoming Attachment to LAN

451 Views 7 Replies 3 Participants Last post by hometoast, Dec 10, 2009

TheLegend

Discussion Starter · Dec 4, 2009

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

Save

1 - 8 of 8 Posts

scottsee

· #2 · Dec 5, 2009

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?

Save

TheLegend

Discussion Starter · #3 · Dec 5, 2009

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.

Save

TheLegend

Discussion Starter · #4 · Dec 6, 2009

Bump.

Save

TheLegend

Discussion Starter · #5 · Dec 8, 2009

To the top.

Save

hometoast

· #6 · Dec 9, 2009

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.

Save

TheLegend

Discussion Starter · #7 · Dec 9, 2009

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.

Save

hometoast

· #8 · Dec 10, 2009

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.

Save

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.

Top Contributors this Month