Hassle-free live chat software re-imagined for business growth. 2 users, always free.
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.
Connect with top rated Experts
23 Experts available now in Live!