0

My company has an issue with Outlook when it is triggered to open by Excel that causes Outlook to hang indefinitely when loading (an issue which cannot be easily fixed). We have a few workbooks with custom ribbons where we now check that Outlook is open first before allowing the user to send via email. The problem is that this doesn't account for users that still use the File > Save & Send > Send as Attachment.

I would like to know if anybody knows about a process by which I can add on a routine to the existing button that we could save as an Excel Add In on everyone's Excel that checks first if Outlook is open? I have the Outlook check written so I'm just needing help with finding a way to run it.

Any help is appreciated.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45
Kyle Mac
  • 146
  • 6

2 Answers2

1

Alternatively you could disable Send as Attachment.

I wouldn't know what is important so I won't copy parts here.

How do you disable “Save and send” in Excel 2010 (in the File ribbon (called backstage in Office 2010)?

Disable the Send button in the Office Menu

Community
  • 1
  • 1
niton
  • 8,771
  • 21
  • 32
  • 52
0

You may consider repurposing the ribbon controls. See Temporarily Repurpose Commands on the Office Fluent Ribbon for more information.

Unfortunately the Backstage UI doesn't allow to repurpose controls from the XML markup. You may consider hiding the built-in UI and rebuilding it fully with custom commands. Thus, you will be able to handle the commands on your own. You can read more about that in the Introduction to the Office 2010 Backstage View for Developers article. Also see the Customizing the Office 2010 Backstage View for Developers article.

Eugene Astafiev
  • 47,483
  • 3
  • 24
  • 45