Need to save CSV from specific email/subject to network folder
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.