Outlook.items.sort "[SentOn]"

[prasaddn]

Hi,

I am using VBA in Excel to connect with Outlook Sent Items folder and save the mail item in shared network drive.

The macro is working fine, the challenge I face is when I try to sort the sent item to pick recently sent item as first email. The below email do works in Outlook 2013

SubFolder.Items.Sort "[SentOn]", Descending:=True

But does not sort the same way in 2010! It picks oldest email in the sent email folder.

based on some website I even tried :
set MyItems as SubFolder.items
MyItems.Sort "[SentOn]", Descending:=True

Still no success. I tried changing True to False but no success.

Any help please.

Regards,
Prasad DN

 

[Deepak]

Check it.

Dim myItems As Outlook.Items
Set myItems = myFolder.Items
myItems.Sort "[SentOn]", True

 

[prasaddn]

Hi,

I tried the exact same, but it does not got sorted.

Is it got something to do with outlook 2010? and it is inside Citrix Environment. In fact, some times it works and most of the times it won't.

and, that is what actually keeps me worrying.

Regards,
Prasad DN