Calling a Macro from Outlook Ribbon

**sonny.thind** · 03-20-2012, 09:19 AM

I have this Macro which I am trying to call from the outlook Ribbon. The macro basically needs to run whenever I click it so it can reply to the message I select.
(I went through the right click ->customize->Macros-> and created this macro shortcut (replywithHTML) onto a new menu toolbar on the ribbon.
however I keep getting a "Project1.RepllywithHTMl macro cannot be found". However when I go into the VB editor the code works.
What seems to be the issue here?
here is the macro in a module in outlook 2007

Please Login or Register  to view this content.

**tkowal** · 03-20-2012, 10:07 AM

Since there is no workbook it hard to tell what is going on.. some things to check are

* Do you have all the correct References checked ... eg Microsoft Office XX Object Library and Microsoft Outlook XX Object Library

The customize Macros will place the button on the quick access tool bar (not on the ribbon) ....

**sonny.thind** · 03-20-2012, 11:39 AM

Hi

Yup got both of those checked up. There wont be a workbook because this module is in Outlook. Yes that's where the Macro is run form Pardon my ignorance..
is the macro ok?? does it need a cleanup ??

**tkowal** · 03-20-2012, 03:52 PM

My bad ... I was answering other excel questions and should have read the subject line and saw that it was an Outlook question.....

BTW I copied your code as is into a Project1 ---> inserted a module Module 1 and pasted your code and it appears to run fine when I placed a button on the ribbon.

The references I have set are
Visual Basic For Applications
Microsoft Outlook 12.0 Object Library
OLE Automation
Micorsoft Office 12.0 Object Library

**sonny.thind** · 03-21-2012, 08:00 AM

Thanks !!

yo know what I Got this working with your method-- I redid the macro into a new module3 saved and then restarted outlook, opened up ,did the Ribbon thing again , and then restarted and then tried the macro. Voila!! it worked..

Well your opinion sure helped !!..

Regardsss.