Your question, your audience. Choose who sees your identity—and your question—with question security.
Sub ReplyToAllSelected() Const REPLY_TEXT = "Thanks the data has been updated." Dim olkMsg As Object, _ olkReply As Object For Each olkMsg In Application.ActiveExplorer.Selection Set olkReply = olkMsg.Reply If olkReply.BodyFormat = olFormatHTML Then olkReply.HTMLBody = REPLY_TEXT & "<br><br>" & olkReply.HTMLBody Else olkReply.Body = REPLY_TEXT & vbCrLf & vbCrLf & olkReply.Body End If olkReply.Send Next Set olkMsg = Nothing Set olkReply = Nothing MsgBox "All done!", vbInformation + vbOKOnly, "Reply to All Selected" End Sub
Join the community of 500,000 technology professionals and ask your questions.