+ Reply to Thread
Results 1 to 5 of 5

Calling a Macro from Outlook Ribbon

  1. #1
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    112

    Calling a Macro from Outlook Ribbon

    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.
    Last edited by sonny.thind; 03-21-2012 at 08:01 AM. Reason: Solved

  2. #2
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Calling a Macro from Outlook Ribbon

    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) ....

  3. #3
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Calling a Macro from Outlook Ribbon

    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 ??

  4. #4
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Calling a Macro from Outlook Ribbon

    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
    Ted
    "Live Long and Prosper"

  5. #5
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    112

    Re: Calling a Macro from Outlook Ribbon

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1