Scroll to next email received

[DMT Dave]

Hi Guys, is there a method of having a button to scroll the the next email (received after the current one) via a cmd Button ?



This is a loose attempt but my lack of understanding won't make it work at all, thank you

Dim oItem As MailItemDim outApp As Outlook.Application
Dim objItem As Object
Dim olExplorer As Outlook.Explorer
Dim sText As String, vText As Variant, i As Integer




Set oExplorer = outApp.ActiveExplorer
Set oItem = objItem


If oExplorer Is Nothing Then
    MsgBox "No Outlook explorer open!", vbCritical, "No Outlook Explorer"
End If


If oExplorer <> 0 Then
    For Each objItem In ActiveExplorer.Selection
    With oItem
    sText = oItem.Body
    vText = Split(sText, Chr(13))
    For i = UBound(vText) To 0 Step -1
    vItem = Split(vText(i), Chr(9))
    Me.txtMailMessage = vText
    End With
End If
    Next i


Set outApp = Nothing
Set objItem = Nothing
Set oExplorer = Nothing

[Welshgasman]

Identify how many emails are selected, store that in a public variable/TempVar then use another variable to increment and use that to select the next email?

[DMT Dave]

Hi welshgasman, ok, is it possible if you have some vba to post to get me started on ?

Kindest

[Welshgasman]

I have none,it was a just a theory from writing the attachments code?

[Gicu]

Hi Dave,
What do you mean by "scroll" to the next email? Do you want to actually control the Outlook window to load the next email or you want to present that in Access on your form. Please have a look at my free utility http://forestbyte.com/ms-access-util...ook-companion/ that has a form to look at any specified folder in Outlook.
Cheers,

[orange]

I haven't done anything with outlook for years. Hope this is useful.
But I recall blueclaw having several examples that were often referenced.

If you search this forum using Outlook and attachment or similar you'll find several hits.

I was thinking of a For Loop generally and found this thread.

[DMT Dave]

Thank you guy's will check it out, Yes Vlad, thank you, if when we open inbox, there may be 20 new mails to respond to in which our db will check the email address to confirm a user has replied

so rather than keep minimizing windows to select the next mail from inbox, a button to select the next email

also we would click on the 1st mail arrived so that's what I meant by working to next mail when received later than the current one

Will give it a go, thank you all again

[Gicu]

I think the frmReadEmail in my utility would work for you with some adjustments, have a look and post back please.
Cheers,

[DMT Dave]

Hi Vlad, thank you, yes will take a look soon as i get chance, been dragged away from it temporarily but will certainly and much appreciated as always