On a daily basis i receive an email with an attachment (the email will come from one of three different people). I want to be able to open this attachment, move the data into my workbook, then run my vba code on it (This to modify it, save as a txt file and close). The attachment has a different name each day - a string of 12 different letters or numbers, but always ends ".000001.csv", if that helps.
My code to modify etc all works fine. The part i'm struggling with is the Outlook link. I have searched far and wide but i'm not finding anything suitable (although my lacking knowledge may also be at play here). The issue generally seems to be that people want code to loop through their entire inbox, whereas i just want it to find the most recent email from said recipient, execute then stop. It goes to a general inbox and therefore it has to be specific as i do not want to open 1000+ attachments by accident!
I only receive one email per day from this recipient, hence a "today" qualifier may be useful (although not required) to prevent it opening yesterdays/previous email.
I have my code if required, but none is relevant to the question so i don't want to 'muddy' the answer.
Many thanks in advance!