Database Search

TechHome

Redemption

• Add Attachment to Journal Item
• Adding Contact Information into Outlook
• Compiled EXE Keeps Running Under Task Manager
• Copy Contacts Folder to Subfolder in Outlook
• Create a Folder under Personal Folders in Outlook
• Create Outlook Distribution List
• Creating Address Book XML File
• Current Contact Folder Items
• Delete Mail from Outlook using OLE
• Delete Outlook Contact
• Email Forwarder
• Embed an Image into an Outlook Email
• Empty Folder in Outlook
• Encrypt Message in Outlook
• Find Contacts in Outlook
• Find Folder with the String Mailbox
• Get Internet headers Field from Outlook Message
• Get Contact data form Contact Item Currently Selected in Outlook
• Get Contact Information In Outlook
• Get Internet headers Field from Outlook Message
• Get list of appointments
• Get member of Outlook Distribution List
• Get Outlook Contact information
• How to Send Mail from Outlook using OLE
• Identify Outlook Folder Type or Contents
• Import Excel Data into Outlook Contact Folder
• Launch Outlook and Make Visible
• List Subfolders
• Mark Messages as Read in Outlook using OLE
• ObjectEventAdd To Capture ItemSend Event
• OLE and OUTLOOK check mail
• OLE and OUTLOOK read mail other than inbox
• OLE and OUTLOOK read mail
• OLE MAPI Choose Folder
• OLE_Outlook- add Entry to Address book
• Outlook - Get Oldest Email Message
• Outlook constants
• Outlook Contacts to XML
• Outlook PST to MSG Export
• Outlook Quit Event
• Outlook Received Date
• Outlook Reply-To in OLE
• Outlook Sendmail OLE Example
• Outlook Version
• Read Open Active Outlook Message
• Recurse Outlook folders
• Redemption Causes WinBatch Studio to Crash
• Rename Personal Folder in Oulook
• Save file attachments in Outlook
• Save outlook attachments
• Send to Multiple Recipients
• Sort Email by Received Time
• TypeOf Equivalent
• Use Existing Instance Or Create a New One If Necessary
• Using OLE to resolve name in Outlook
• WinBatch and Redemption Issue
• Writing Appointments to Outlook

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

Outlook - Get Oldest Email Message

objOutlook = ObjectCreate ("Outlook.Application")
objNs = objOutlook.GetNamespace("MAPI")
objFolderInbox  = objNs.Folders("Personal Folders").folders("Inbox")
objMailItems = objFolderInbox.Items
mailitemcount = objMailItems.Count
;Get oldest Mailitem
oldestrcvd = 0
oldestentryid = 0
For xx = 1 To mailitemcount
    objMailItem=objFolderInbox.Items( xx )
    receivedtime = objMailItem.ReceivedTime
    entryid = objMailItem.EntryId
    If xx == 1
       oldestrcvd = receivedtime
       oldestentryid = entryid
    Else
       If receivedtime < oldestrcvd
          oldestRcvd = receivedtime
          oldestEntryId = entryid
       EndIf
    EndIf
    objMailItem= 0
Next

;Get Data from oldest message
objMailItem = objNs.GetItemFromID(oldestEntryId)

receivedtime = objMailItem.ReceivedTime
subject = objMailItem.Subject
body = objMailItem.Body
Message( "Oldest Message", "[ReceivedTime]: ":receivedtime:@CRLF:"[Subject]: ":subject:@CRLF:@CRLF:"[Body]: ":body)

;Clean up
objMailItem = 0
objMailItems = 0
objFolderInbox = 0
objNs = 0
objOutlook = 0
Exit

Article ID:   W17129

File Created: 2007:07:03:14:28:26

Last Updated: 2007:07:03:14:28:26