After much searching, I've been unable to find a solution to this specific issue.
I will be receiving (from one specific email address only), PDF files (one per email) reporting on team members, such that the file name will include the member's last name along with other words.
I'd like to have VBA to automatically:
  • check if from that one email address
  • then check to see if the attachment contains a specific name
  • then save that file to a specific folder based on that name (without altering the filename of the attachment)
Currently have two team members but the list would grow. I would modify/add code as new are added (assuming an if/then/else??)

Thank you in advance for any direction and help!