Thread: [Solved] VBA Support required (trying to automatically filter PDFs from emails in specific folders.
View Single Post
 
Old 11-17-2014, 07:45 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,137
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 ofgmayor has much to be proud of
Default
The macro I posted will simply increment the number of the file being downloaded as the messages arrive. If the messages are processed as they arrive then presumably they will carry the latest version and if the filename is the same it should be safe to save the attachment overwriting the existing file, instead of incrementing it.

The existing messages are a bit more of an issue. I'll have to think about that a bit more. However, if they are all in the same Outlook folder then all it should take is to sort the folder by date and time of arrival and process the files in reverse order (or conversely sort them in reverse order and process the files in the sorted order).

Would that work for you?
__________________
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