Hi Everyone. Just like to preface this by saying I am a complete noob at VBA.

Scenario
  • Email comes in every day (between 7:30am - 8am EST) from same group email with same subject and with CSV with same file name
  • Everyday the receiver of the email needs to manually save the CSV file to network share
  • Someone else runs a power shell script to process the contacts of the CSV file


Goal
  • Create VBA code or some other method to move file
  • Check new emails for specific sender, specific subject line, and specific CSV file name
  • If above criteria matches, do the following:
    • Copy the CSV file to a specific network share keeping the same file name
    • Move the email in Outlook from inbox to "Done" folder to prevent file from being processed again


Things I have done so far
  • Checked into using Power Automate but the company I work for currently has it disabled
  • Did some google searches and found some examples but the code found is really complicated and I am a noob


Any help would be appreciated and thanks in advance.