MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 272|Reply: 5

Preventing that accidental Reply All, any add-ins or Macros

[Copy link]

46

Topics

232

Posts

572

Integral

Lord

Rank: 4

Integral
572
Post on 11-3-2016 21:43:03 | All posts |Read mode
Finally did it, luckily it was nothing to worry about. However, I want to nip this right in the bud. Is there a way to either have a confirmation that I want to reply all before sending? I saw one website suggest removing the reply all from the ribbon, but i have 2016 and it will not let me.
Reply

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 11-4-2016 07:46:34 | All posts



Outlook has a 'ReplyAll' event which you can intercept just like any event in Excel - and it includes a Cancel facility. Pop a message box asking if you want to continue and allow/cancel depending on the reply.
Not sure if you're happy to add VBA code to Outlook, so just a quick answer. Post back if you want specifics.
Reply Support Opposition

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 11-8-2016 15:44:53 | All posts



Outlook has a 'ReplyAll' event which you can intercept just like any event in Excel - and it includes a Cancel facility. Pop a message box asking if you want to continue and allow/cancel depending on the reply.
Not sure if you're happy to add VBA code to Outlook, so just a quick answer. Post back if you want specifics.




Reply Support Opposition

Props Report

46

Topics

232

Posts

572

Integral

Lord

Rank: 4

Integral
572
 Author| Post on 11-8-2016 16:15:52 | All posts



Yeah, any add-ins or Macros/VBAs I am willing to take a swing at.
I am familiar with macros in Excel. Not writing, but adjusting somewhat
Reply Support Opposition

Props Report

46

Topics

232

Posts

572

Integral

Lord

Rank: 4

Integral
572
 Author| Post on 11-9-2016 05:47:34 | All posts



Yeah, any add-ins or Macros/VBAs I am willing to take a swing at.
I am familiar with macros in Excel. Not writing, but adjusting somewhat




Reply Support Opposition

Props Report

7

Topics

551

Posts

1283

Integral

King

Rank: 6Rank: 6

Integral
1283
Post on 11-9-2016 06:59:54 | All posts



The following goes in the ThisOutlookSession module (Alt-F11 to get to the Outlook VBA environment, same as Excel)
Option Explicit
Private WithEvents oOE As Explorer
Private WithEvents oMI As mailItem
Private Sub Application_Startup()
   
   '// Get events for the Outlook Explorer window
   Set oOE = Application.ActiveExplorer
End Sub
Private Sub Application_Quit()
   '// Explicitly delete used objects
   On Error Resume Next
   Set oOE = Nothing
   Set oMI = Nothing
   
End Sub
Private Sub oOE_SelectionChange()
   
   On Error Resume Next
   
   '// As oMI is declared as MailItem it will error if any other
   '// type is selected (Calendar, Contact etc) - Ignore
   Set oMI = oOE.Selection.Item(1)
   
End Sub

Private Sub oMI_ReplyAll(ByVal Response As Object, Cancel As Boolean)
   
   Cancel = (MsgBox(Are you sure you want to reply to ALL the original recipients...?, vbYesNo + vbQuestion + vbDefaultButton2, Flame retarder) = vbNo)
   
End SubI'd seriously doubt there's any existing code, but if there is, any 'duplicate' procedures will have to be combined.
You must restart Outlook after making any changes and this will cause the 'Enable Macros' prompt when Outlook starts.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-25-2017 11:49 , Processed in 0.236294 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!