View Single Post
 
Old 11-24-2015, 04:38 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default Sorting the Outlook inbox before searching for an email

Hi,

I have a macro searching the Outlook inbox for a specific mail, then downloading an attachment from this email and processing it to get a specific figure and just paste it into another XL file.
That's working fine so far.

The issue is, the code always parses the inbox from bottom to top, that is, from the oldest item to the newest (we have it sorted so that the newest items are on top by default). That way, it will take a while since those guys never delete anything from that inbox and so there is a large number of emails there.

Is there any way to either change the sorting_order of the inbox beforehand or change the order in which the loop runs (it is a FOR NEXT loop)?
I've tried that >Sort< method, but that doesn't seem to work yet.

Thanks a lot!

Best a regards,

Officer_Bierschnitt
Reply With Quote