Move Outlook File To Local Drive

' CURRENT SCRIPT: This script currently works as a macro when the above is removed from the sub title (xxxxx As [login to view URL]) ' *this script needs to be able to work from an outlook mail rule "run script" ' ' ' CURRENT PROBLEMS ' *- Can not search for files in Inbox subfolder in subsubfolder (Inbox\DATA DUMP\Stock On Hand) ' *- Can not call the script from an outlook run script macro ' *- Can not search and select inbox file by file name ' *- '***************************************************************** ' SUMMARY NOTES ' This Outlook VBA macro searches for a file attachment in an Inbox subfolder in a sub folder (This example: Inbox\DATA DUMP\Stock On Hand) ' This Outlook VBA macro searches for a file attachment for a specific file type or name then, (This example: .CSV extention or [login to view URL]) ' if true the attachement file is renamed and saved to local drive folder. (This example: c:\data dump\Stock On Hand\Stock On Hand [login to view URL]) ' once the script has been executed the subfolder file is deleted ' *If the renamed file name is not unique then the original file will be replaced each time the outlook macro executes ' ' STEPS TO SETUP: "Outlook Auto File Mover" ' ' OUTLOOK SETUP ' Create outlook subfolders within the inbox folder: DATA DUMP\Stock On Hand\ ' Create outlook rule: When file with name arrives move to folder (Inbox\DATA DUMP\Stock On Hand) ' Create outlook rule: "run script" that point to this script ' ' VBA SETUP - in Outlook press Alt + F11 and Add Script Add Reference: ' Create a Module and add This Script ' Add Reference: Excel x Object Library ' Add Reference: Microrsoft outlook Object Library ' ******************************************************************************************************** See attached script