excel macro that reads and process outlook e-mail attachments

[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,

Please post VBA questions in forum707. Your will get better responses in that forum rather than in this one.

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