The GetLast method returns the last AppointmentItem, GroupHeader, MeetingItem, or Message object in the Messages collection. It returns Nothing if no last object exists.
Set objMessage = objMsgColl.GetLast( [filter] )
If the filter parameter is set, the GetLast method returns the last message in the collection with a Type property matching the value of filter. However, if the Messages collection is in a calendar folder, the filter parameter is not supported. Microsoft® Outlook™ ignores any setting of filter and returns the last appointment, while Microsoft® Schedule+ returns CdoE_TOO_COMPLEX if filter is set.
The Get methods normally return a Message object but can also return an AppointmentItem, GroupHeader, or MeetingItem object.
The order that items are returned by GetFirst, GetLast, GetNext, and GetPrevious depends on whether they are sorted or not. The AppointmentItem, GroupHeader, MeetingItem, and Message objects within a collection can be sorted on a MAPI property of your choice, either ascending or descending, using the Sort method. When the items are not sorted, you should not rely on these methods to return the items in any specified order. The best programming approach to use with unsorted collections is to assume that the access functions are able to access all items within the collection, but that the order of the objects is not defined.
The Get methods sometimes perform more efficiently if you have applied a MessageFilter object to the collection.
If a Messages collection has not been enumerated since it was initialized, the behavior of the GetLast method is not defined. A collection is enumerated when you call its GetFirst method, access a member through its Item property, or use its Filter property to specify a message filter. Some providers may return CdoE_CALL_FAILED if you call GetLast before the collection is enumerated.
Microsoft Schedule+ does not support GetLast on a Messages collection of AppointmentItem objects.