(Visual FoxPro) Fetch Oldest/Newest IMAP Email

Emails may be downloaded by sequence number. Assuming the selected mailbox is not empty, the oldest email is at sequence number 1, and the newest email is at sequence number N. The FetchSingle method may be used to download by sequence number.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loImap
LOCAL lnSuccess
LOCAL n
LOCAL lnIsUid
LOCAL loOldestEmail
LOCAL loNewestEmail

* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Imap')
loImap = CreateObject('Chilkat.Imap')

* Connect to an IMAP server.
* Use TLS
loImap.Ssl = 1
loImap.Port = 993
lnSuccess = loImap.Connect("mail.testemail.net")
IF (lnSuccess <> 1) THEN
    ? loImap.LastErrorText
    RELEASE loImap
    CANCEL
ENDIF

* Login
lnSuccess = loImap.Login("***","***")
IF (lnSuccess <> 1) THEN
    ? loImap.LastErrorText
    RELEASE loImap
    CANCEL
ENDIF

* Select an IMAP mailbox
lnSuccess = loImap.SelectMailbox("Inbox")
IF (lnSuccess <> 1) THEN
    ? loImap.LastErrorText
    RELEASE loImap
    CANCEL
ENDIF

* After selecting a mailbox, the NumMessages property
* contains the number of emails in the selected mailbox.

n = loImap.NumMessages

IF (n > 0) THEN

    * The oldest email is always at sequence number 1.
    lnIsUid = 0

    loOldestEmail = loImap.FetchSingle(1,lnIsUid)
    IF (loImap.LastMethodSuccess = 1) THEN

        * Display the From and Subject
        ? loOldestEmail.FromAddress
        ? loOldestEmail.Subject

        ? "--"
        RELEASE loOldestEmail
    ENDIF

    * The newest email is at sequence number N:

    loNewestEmail = loImap.FetchSingle(n,lnIsUid)
    IF (loImap.LastMethodSuccess = 1) THEN

        * Display the From and Subject
        ? loNewestEmail.FromAddress
        ? loNewestEmail.Subject

        RELEASE loNewestEmail
    ENDIF

ENDIF

* Disconnect from the IMAP server.
lnSuccess = loImap.Disconnect()

RELEASE loImap