Excel macro that will move Outlook e-mail attachments to local folder

[3PipeProblem]

We have an excel macro that reads and process data files located in local computer directory. These files are outlook e-mail attachments and are currently hand copied from a personal e-mail folder (placed there by email rule) to the local computer directory. This process was fine when there were only two to three e-mails per week, but now we are getting more than five files per day. Since we are not allowed to run outlook macros, I want to write a excel macro or VB program to scan outlook personal mail folder for messages containing e-mail attachments and save them to a local computer directory for processing by the excel program.Any ideas

 

[SkipVought]

Hi,

Set a reference to the Microsoft Outlook Object Library in Tools > References in the VB Editor.

Use CreateObject to create an Outlook application object.

Then code your outlook application objects' properties & methods.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]