Cannot run create macros within Outlook 2007

Status
Not open for further replies.
B

bmcknight



I have a user who is able to record macros within Word and run them. However, when she attempts to run the macro within an open Outlook message (by going to the "Macros" button that is within the Developer tab of an open message window, these same macros do not initially appear despite the fact that Word is the exclusive editor for Outlook 2007. To the best of my understanding according to Microsoft, is is not possible to record macros within Outlook (if you can, I do not see where or how). It is possble to make the macro appear within Outlook if you were to copy the subroutine pertaining to the macro from Word's Visual Basic editor to Outlook's Visual Basic editor, but when you then actually attempt to run the macro within Outlook, you get the following error message

----------------------------- Runtime Error '424'
Object Required
----------------------------

According to the below, referenced article (authored by Sue Mosherwho I guess is a top of the line Outlook expert), this is because "the Outlook object model does not support an intrinsic Selection object". Code is provided within the article which is designed to enable the Outlook message to access a Word.Selection object. However, when I attempted to incorporate this code into Outlook Visual Basic editor to run a test macro, I got the following error message:

---------------------------------------------- Compile error:
User-defined type not defined
----------------
Should I be modifying this code to a greater extent? I have some VB experience as a student, but not on a pro level. Regardless, I would like to be able to get my user to be able to run her macros within an Outlook e-mail.

http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!579.entry&sa=79757417
 
B

billja-ms



Hi,

Typically that error message is a sign that you did not reference the Word object library in Outlook's Visual Basic Editor (VBE). Without doing this, Outlook VBA code wouldn't know what a "Word" object is in your code. So in the VBE, be sure to go to Tools / References and then scroll down in the list to enable the "Microsoft Word 12.0 Object Library" (I believe that's what it's called, I don't have an Office 2007 machine in front of me at the moment).

Bill Jacob
Microsoft Customer Service and Support - Messaging Developer
 
Status
Not open for further replies.
< Reply address is the outgoing mail address rather than the incoming.... | OUTLOOK NO LONGER SHOWS MESSAGE BODY....... >
Thread starter Similar threads Forum Replies Date
L Cannot run script from rule Outlook VBA and Custom Forms 7
L Cannot update Location field in Contacts - Runtime Error 438 Using Outlook 0
G With my PC, running on operating system Vista SP2, I cannot synchronise Microsoft Notes (Outlook 2003 SP3) with my iphone 3GS Using Outlook 3
S outlook error 0x80070021 a prosses has outlook files open and backup cannot run Using Outlook 2
J I cannot open outlook. It says errors have been detected in the file. It says to run scanpst.exe but__I cannot find it on the computer. Can I get help Using Outlook 1
Similar threads
Cannot run script from rule
Cannot update Location field in Contacts - Runtime Error 438
With my PC, running on operating system Vista SP2, I cannot synchronise Microsoft Notes (Outlook 2003 SP3) with my iphone 3GS
outlook error 0x80070021 a prosses has outlook files open and backup cannot run
I cannot open outlook. It says errors have been detected in the file. It says to run scanpst.exe but__I cannot find it on the computer. Can I get help
Top