Hi all.

I have some code in Excel VBA that counts how many emails were received on a specified date in an Outlook inbox and subfolder.
I need to modify it to exclude certain emails.
My criteria for exclusion are that the email contains an attachment with a specific string contained within the filename.


I'm quite new to interrogating Outlook from Excel, but I think I can work out the bulk of it, I just need help with one aspect of my problem.


Can someone show me a simple method of how to obtain the filename of an attachment contained within an email using VBA from excel? Once I have this I can apply it to my code.

Thank you