Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2014, 07:45 AM
gmayor's Avatar
gmayor gmayor is offline VBA Support required (trying to automatically filter PDFs from emails in specific folders. Windows 7 64bit VBA Support required (trying to automatically filter PDFs from emails in specific folders. 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
  #2  
Old 11-17-2014, 07:53 AM
terrymac terrymac is offline VBA Support required (trying to automatically filter PDFs from emails in specific folders. Windows XP VBA Support required (trying to automatically filter PDFs from emails in specific folders. Office 2007
Novice
VBA Support required (trying to automatically filter PDFs from emails in specific folders.
 
Join Date: Nov 2014
Posts: 8
terrymac is on a distinguished road
Default

Hello Graham,

You are very helpful.

As I will be running this command once only for each folder I have then the simplest way, as you suggested, is to get Outlook to work its way down the list from oldest first, and replacing as it goes. This would ensure I end up with the newest PDFs for each filename.

Then, once I have it all run, all future emails will be instantly uploaded and older PDFs replaced accordingly.

Hopefully I am not being rude in asking if you could edit my original command posted to do this so I could paste it back into the editor?

Regards,
Terry.
Reply With Quote
  #3  
Old 11-17-2014, 08:33 AM
gmayor's Avatar
gmayor gmayor is offline VBA Support required (trying to automatically filter PDFs from emails in specific folders. Windows 7 64bit VBA Support required (trying to automatically filter PDFs from emails in specific folders. 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

I haven't got time today, but I'll modify it for you tomorrow, if no-one else picks it up overnight.
__________________
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sent emails end up in both Sent and Draft folders Begadoc Outlook 2 11-26-2013 02:42 PM
How to set style automatically for specific texts ragesz Word 2 07-25-2013 07:08 AM
5 Folders Automatically Created under Inbox of Outlook 2007 yashwant Outlook 0 04-26-2012 12:28 AM
VBA Support required (trying to automatically filter PDFs from emails in specific folders. Merging outlook folders and emails rudihorvath Outlook 1 03-16-2012 07:03 AM
Current view filter applies automatically lumisy Outlook 3 03-25-2011 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft