items.Sort ordered for more fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MClaudio - 02 Jan 2006 14:56 GMT

Hi,

I cannot sort items in my folder for more fields ?!?
Why ?

Set MyArchivio =
Application.GetNamespace("MAPI").Folders("CartellePubbliche").Folders("Tutte
le cartelle pubbliche")..Folders("Societa")

set MyItems=MyArchivio.Items
MyItems.Sort "NumeroOrdine"
MyItems.Sort "AnnoOrdine"

When i read Myitems with for Each the elements isn't ordered.

Thanks

Reply to this Message

Ken Slovak - [MVP - Outlook] - 02 Jan 2006 15:26 GMT

Your code first sorts on "NumeroOrdine", then discards that sort to sort on
"AnnoOrdine". Outlook only allows sorting on one field at a time.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

> Hi,
>
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

MClaudio - 02 Jan 2006 16:50 GMT

This is a big problem !!!
How can i order more fields ?

Thanks

> Your code first sorts on "NumeroOrdine", then discards that sort to sort on
> "AnnoOrdine". Outlook only allows sorting on one field at a time.
[quoted text clipped - 15 lines]
> >
> > Thanks

Reply to this Message

Ken Slovak - [MVP - Outlook] - 02 Jan 2006 20:35 GMT

You'd have to abandon using the Outlook object model's Items.Sort method and
code your own multiple column sorting procedure, then pass the Items
collection to that user defined procedure.

Signature

> This is a big problem !!!
> How can i order more fields ?
>
> Thanks

Reply to this Message