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
|