Saving attachments in multiple emails in outlook 365

[Mr_Phil]

Hi, we just started a big project and my team leaders are sending in reports. The reports are attachments to an email. I know I can select one email and choose to save all attachments. But, with a couple of hundreds emails all with one or two attachments that is going to be a time suck. I tried selecting multiple emails and there's no option to save all the attachments.

Does anyone have a workaround?
Macros don't scare me either. I'm ok with Excel macros so I figure I have a shot at learning Outlook Macros...

Thanks for looking.

[dflak]

I had to do this in a prior job, here is the code I used.

This code reads an incoming subfolder directly under the INBOX, strips out the attachments to the specified Excel folder and then moves the mail to a processed folder that is directly under the subfolder

Set up the parameters as named ranges. Look at the initialize variables section to get the names.

The only thing that should need explanation is KeepFiles. It defines what kind of files you want to download separated by columns. So *.xlsx,*.csv will download XLSX files and CVS files if any but not PDF, JPEG or other types of files.

Please Login or Register  to view this content.

[Mr_Phil]

That looks like just the ticket. Thank You.