Please see reference thread:
https://www.excelforum.com/outlook-p...f-outlook.html
I hesitated between replying to the above linked thread or starting a new one, because my question is basically the same as cmorten82's, word for word... the only difference I can see that would make me think the offered solution wouldn't also work for me is that I need my incoming attachments saved automatically, as they arrive, with no manual intervention whatsoever. My files arrive hourly, not daily, and the basic idea is that our company's bookkeeping program, "Epicor", is feeding me raw data hourly that I need automatically saved as it arrives, overwriting the last saved version, so that another spreadsheet has access to the most current data without having to interact directly with Epicor. The way our system is set up, I either have to manually run the required reports from Epicor and then export the result as an Excel spreadsheet, or I can have the IT department schedule the report to run automatically on a recurring interval and email me the spreadsheet version of the results. I still then need to save the attachment myself in order for the info to be accessible by my other spreadsheet... so I need to fully automate the process of saving attachments as they arrive.
While dflak's program appears to be quite impressive and powerful, as I understand it this method would still require me to open a file and click a button in order to pull and save the attachments. I need them to automatically save in place of the previous saved version as they arrive, without prompting me to confirm that I want to overwrite the existing file. My computer stays on and running 24/7, and I already have a folder in my inbox set up with a rule that moves all incoming mail generated by Epicor to that folder (named "Epicor")… but I don't have the slightest idea how to get it to automatically save the attachment to a folder on my desktop (or preferably, on a network drive). Ideally, I would also have the email and attachment deleted from the "Epicor" email folder once the attachment has been saved in the desktop/network folder, but that is more a matter of housekeeping, and isn't essential for functionality. If I can automate the saving of the attachments, I don't mind having to essentially dump a trash can once a week... It sure would beat having to open an email and save an attachment once an hour, every hour, every day of the week.
I don't need any fancy sorting or email searching, as any email that hits the "Epicor" folder with an attachment should simply have that attachment blindly saved to the destination folder. If the filename already exists, it should overwrite the existing file with the new file, without asking first (or apologizing afterwards). My Excel file will search that folder for the specific filename of the relevant Epicor generated report, so any other attachments "accidentally" automatically saved will just be ignored. This allows me to have different reports run and sent to me for other purposes in the future without the need for any additional code on the email side, as each different report will have a different file name. The destination folder simply needs to be a "dump bin" for all attachments that end up in the "Epicor" email folder.
Seems like it should be a simple task, but I haven't messed with VBA in Outlook at all, or really anywhere but within Excel. And, to dflak's credit, every attempt at googling for the simplest or best way to do what I need done has landed me right back at another instance of the file offered as a solution in the linked thread above... so it has to be an awesome tool indeed, but in this case it's a precision screwdriver, and I need something more like a dull, rusty hammer. Or an old chunk of broken concrete.
Any help here would be greatly appreciated... Thanks in advance!
Bookmarks