Mac – How to get a macro to run in Outlook 2010

macrosmicrosoft-outlookmicrosoft-outlook-2010trust

I've written a macro for Outlook and would like it to be run from a button which is visible whenever you compose an email. As such, I've added a button to the Quick Access Toolbar pointing to the macro, given it an icon and renamed it.

I've also gone into the Trust Center (File > Options > Trust Center > Trust Center Settings.. > Macro Settings) and changed the security level to "Notification for all macros".

I've restarted Outlook yet when I click on the button nothing happens. In Outlook 2003 and Outlook 2007, this would have been enough to get the macro to run.

I've added a breakpoint to the first line of the macro and it is never run. I can only conclude that this means that somewhere Outlook 2010 is still stopping macros from being run.

Does anyone know what else I need to do to encourage Outlook 2010 to run macros?

Best Answer

You need more info for me to give you a good enough answer, but here's a quick overview of what I did and was successful to get a macro going.

If you're looking to have a macro run based on an event:

This means you're looking to have your code run based on events that happen within outlook. For example, Application_Startup.

Under the Developer IDE (Alt + F11) select Microsoft Outlook Objects -> ThisOutlookSession

enter image description here

Then Select the dropdown that says General and Select Application. You'll then be able to select all the event driven methods that you can add. For Example:

enter image description here

If you're looking to just run a Macro

In the IDE, select the toolbars creation button dropdown and select Module

enter image description here

Within the code, create you're module:

Sub test()

    MsgBox "Hey Look a Macro!"
    
End Sub

You can then run it from the Developer tab:

enter image description here

Note: You have to make sure that you enable ALL macros in the security center

For more information I would highly suggest you read up on the Developer's website material.

Related Solutions

Outlook – What would an Outlook 2007 macro to automate Paste Special – Unformatted Text look like

With lots of help from author Sue Mosher, I have finally managed to get a macro working on Outlook 2007 to automate the mouse clicks of Paste – Paste Special – Unformatted Text! WOO-HOO!!!!

Most of what I cut and paste into Outlook email messages is formatted. Pasting with CTRL-V or by clicking the Paste button keeps that formatting intact. Clicking Paste – Paste Special – Unformatted Text isn’t a big deal, but it takes a couple of seconds every time I do it – and I do it a LOT. So this little thing will be a timesaver for me.

The VBA subroutine:

Sub Paste_Special_Unformatted()
    Dim objDoc As Word.Document
    Dim objSel As Word.Selection
    On Error Resume Next
    ' get a Word.Selection from the open Outlook item
    Set objDoc = Application.ActiveInspector.WordEditor
    Set objSel = objDoc.Windows(1).Selection
    ' now do what you want with the Selection
    objSel.PasteSpecial Link:=False, DataType:=wdPasteText
    Set objDoc = Nothing
    Set objSel = Nothing
End Sub

To get it to work, I also needed to open the VBA editor in Outlook 2007, click Tools – References, and enable the reference for Microsoft Word 12.0 Object Library. I then linked the macro to a custom button in the QAT toolbars for creating new messages and replies and it worked just fine!

I may have mentioned this before, but WOO-HOO!!!!

Thank you, Sue!

Mac – How to execute Outlook 2010 macro with AutoHotKey

It turns out that this is rather easy to do. I had already added my three macros to the home strip in the Outlook ribbon and discovered that you can't bind shortcut keys as you could when adding items to the old toolbar. But what I didn't notice, is that shortcuts are automatically assigned to the new ribbon items, as seen in the screenshot.

alt text

Knowing that, it's possible to invoke these functions with three keystrokes; Alt-H, followed by Y1, Y2 or Y3. Taking this a step further I modified my AutoHotKey script to send these keystrokes and have now reduced these to the single keystrokes Alt-1, Alt-2 and Alt-3. Here is the script.

#IfWinActive, ahk_class rctrl_renwnd32
!1::
Send, {ALTDOWN}H{ALTUP}Y1
return

!2::
Send, {ALTDOWN}H{ALTUP}Y2
return

!3::
Send, {ALTDOWN}H{ALTUP}Y3
return

Best Answer

If you're looking to have a macro run based on an event:

If you're looking to just run a Macro

Related Solutions

Outlook – What would an Outlook 2007 macro to automate Paste Special – Unformatted Text look like

Mac – How to execute Outlook 2010 macro with AutoHotKey

Related Question