Results 1 to 10 of 12

Thread: VBA to Reply All To Latest Email Thread

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    As long as it working

    I was modifying my code. For my interest, could you test this and let me know

    Code:
    Option Explicit
    
    Sub ReplyMail_No_Movements()
    
        Dim olApp As Outlook.Application
        Dim olNs As NameSpace
        Dim Fldr As MAPIFolder
        Dim objMail As Object
        Dim objReplyToThisMail As MailItem
        Dim lngCount As Long
        Dim objConversation As Conversation
        Dim objTable As Table
        Dim objVar As Variant
        Dim strBody As String
        
        Set olApp = Session.Application
        Set olNs = olApp.GetNamespace("MAPI")
        Set Fldr = olNs.GetDefaultFolder(olFolderInbox)
        
        
        lngCount = 1
        
        For Each objMail In Fldr.Items
            If TypeName(objMail) = "MailItem" Then
                If InStr(objMail.Subject, "REQUEST FOR OVERTIME") <> 0 Then 'REQUEST FOR OVERTIME
                    Set objConversation = objMail.GetConversation
                    Set objTable = objConversation.GetTable
                    objVar = objTable.GetArray(objTable.GetRowCount)
                    Set objReplyToThisMail = olApp.Session.GetItemFromID(objVar(UBound(objVar), 0))
                    With objReplyToThisMail.ReplyAll
                        strBody = "Hello " & "<br>" & _
                                    "<p>Following up with the below. May you please advise?" & _
                                    "<p>Thank you," & vbCrLf & vbCrLf & "<br>" & _
                                    "<p>" & Session.CurrentUser.Name
                        .HTMLBody = strBody & .HTMLBody
                        .Display
                    End With
                    Exit For
                End If
            End If
        Next objMail
        
        Set olApp = Nothing
        Set olNs = Nothing
        Set Fldr = Nothing
        Set objMail = Nothing
        Set objReplyToThisMail = Nothing
        lngCount = Empty
        Set objConversation = Nothing
        Set objTable = Nothing
        If IsArray(objVar) Then Erase objVar
        
    End Sub
    Last edited by Excel Fox; 12-04-2018 at 09:24 PM. Reason: Removed unnecessary variable
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 192
    Last Post: 08-30-2025, 01:34 AM
  2. Replies: 19
    Last Post: 04-20-2019, 02:38 PM
  3. Table Tests. And Thread Copy Tests No Reply needed
    By DocAElstein in forum Test Area
    Replies: 1
    Last Post: 11-20-2018, 01:11 PM
  4. Replies: 8
    Last Post: 04-13-2014, 02:38 PM
  5. Moving Current Latest Data To New Workbook
    By Terry in forum Excel Help
    Replies: 1
    Last Post: 01-19-2013, 12:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •