View Single Post
 
Old 09-12-2015, 12:59 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Outlook VBA is very similar to Excel VBA, once you open the VBA editor. Insert a module in Project1 and copy allo the code there. Then locate the line
Code:
Const strSaveFldr As String = "D:\Path\Reports\"
and change that to reflect where you want the attachments to be saved.

Copy a message with attachments to a new Outlook folder, select it and run the macro ProcessAttachment. This will demonstrate how it works. If you are happy with the outcome, run the ProcessFolder macro, which will give you a prompt to select the folder to process.

You cannot run the macro from Excel, without extensive modification to it, and it only adds another set of potential problems to do so.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote