How do I automatically save .xlsm email attachments that come to a shared public folder with a specified subject line?
Posted on 2015-01-05
What we need is code that will automatically save *.xlsm attachments on emails with "Specific Subject" on the subject line, then archive the email to another folder (in that shared account) so it's not in the way. I have some code that will automatically save all *.xlsm attachments, and other code that will save all attachments on manually selected emails. Some kind of hybrid code would be the ticket. I am not the owner of the account, so I cannot set rules to it. Hopefully, this module could be exported to two or three other users who also have access to this account.
I'm not that experienced in VBA overall, and more of an Access VBA guy, so the Outlook aspect has me even more in the dark. Since these Excel attachments will ultimately be imported and processed in Access anyway, the very best solution would be to run Access code that finds the incoming email attachments and imports a range directly from them.
You can see I'm not even sure what I should be shooting for. Any pointers would be greatly appreciated!