Originally Posted by
ashleyuk1984
I can't give you the exact solution that you're looking for, but how about looking at it this way....
You said that you receive thousands of emails with the subject of "SF Bill sent to accounts - 123456", and the 6 digits change every time. This makes it unique.
How about, setting up a macro in Outlook to automatically save these attachments to a local folder. The macro will trigger when you receive an email with the subject line that contains "SF Bill sent to accounts -"....
You could also add in another rule if these emails come from a specific email address.
So every time, you receive one of these emails, the attachment is saved to "C:\SF Bills"
The macro can automatically rename this file to your 6 digits... That's if the excel file name is always different, but not unique.
Then.... You can set up another macro in Excel, to look at your list of subjects, and then look for the file in your local drive... if it exists, then print it.
That's probably the way I'd go about it.