Sort and then cut records to Cut records and then sort
- From: "Tony WONG" <x34@xxxxxxxxx>
- Date: Fri, 4 Nov 2005 17:17:29 +0800
i have the following code to sort out the records into a text file.
********************
Set KKK = objfolder.Items
KKK.Sort "Start", False
For Each Item In KKK
If Item.Class = 26 Then
If Item.Start >= Now Or Item.End >= Now Then
With webfile
.writeline Item.Subject
End With
End If
End If
Next
********************
there are too many records in the folder now. i wish to change the code to
cut out the records first and then sort them in ascending order. i tried
out the following code but fail to item into items code. Could you give me
a hand or hints to do it? Thanks a lot.
above method : sort in ascending order first, and then cut the records out
of the date range.
below method : cut the records out of the date range, and then assign them
in a object, and then sort the items in the object in ascending order.
i think i have technical difficulties in assigned the new object at code ROW
5
**********************************
Set JJJ = objfolder.Items
For Each Item In objfolder.Items
If Item.Class = 26 Then
If Item.Start >= Now Or Item.End >= Now Then
JJJ.ItemAdd Item
End If
End If
Next
JJJ.Sort "Start", False
For Each Item In JJJ
With webfile
.writeline Item.Subject
End With
Next
*******************************
.
- Follow-Ups:
- Re: Sort and then cut records to Cut records and then sort
- From: Sue Mosher [MVP-Outlook]
- Re: Sort and then cut records to Cut records and then sort
- From: tony wong
- Re: Sort and then cut records to Cut records and then sort
- Prev by Date: Re: automatically enter salutation.
- Next by Date: Re: Moving records accurately?
- Previous by thread: Open Attachments using code
- Next by thread: Re: Sort and then cut records to Cut records and then sort
- Index(es):
Relevant Pages
|