Michael Hyatt, whose blog is a must-read if you practice Getting Things Done, has provided a great Outlook macro script that automates the process of setting up a weekly review task list. I am a Visual Basic novice and it took me about three minutes to set this up (including creating a custom icon).
I figure I'll save ten times that amount of time every month because now I can click a single button and my Weekly Review is all set up.
Great stuff.
2. I'm not sure if you can directly invoke a VBA macro but you shoul dbe able to construct a script that calls the Macro window (Alt+F8), picks the appropriate macro by position in the list, and then exeutes the macro. I'll try setting that up. As an alternative, you could try invoking the toolbar button by its speed key assignment.
Posted at 6:20AM on Dec 19th 2005 by Marc Orchant
3. Hi,
You could use Outlook with the following command line option:
outlook /recycle /autorun macroname
This brings the currently running instance of Outlook to the front if there is one, otherwise launches Outlook, then it immediately runs the macro specified in macroname.
See also:
1. Outlook | Help | Search for "command line switches"
2. Additional command line switches in http://support.microsoft.com/default.aspx?scid=kb;en-us;296192
3. http://tinyurl.com/yrxg3 then click Switch Reference
Let me know if this answers the question.
Regards,
Marjolein Hoekstra
Posted at 6:20AM on Dec 19th 2005 by Marjolein Hoekstra
4. Can you use ActiveWords to name the VBA events?
Buzz
Posted at 6:20AM on Dec 19th 2005 by Buzz Bruggeman
5. I'm not sure if you can directly invoke a VBA macro but you shoul dbe able to construct a script that calls the Macro window (Alt+F8), picks the appropriate macro by position in the list, and then exeutes the macro. I'll try setting that up. As an alternative, you could try invoking the toolbar button by its speed key assignment.
Posted at 6:20AM on Dec 19th 2005 by Marc Orchant
6. Hi,
You could use Outlook with the following command line option:
outlook /recycle /autorun macroname
This brings the currently running instance of Outlook to the front if there is one, otherwise launches Outlook, then it immediately runs the macro specified in macroname.
See also:
1. Outlook | Help | Search for "command line switches"
2. Additional command line switches in http://support.microsoft.com/default.aspx?scid=kb;en-us;296192
3. http://tinyurl.com/yrxg3 then click Switch Reference
Let me know if this answers the question.
Regards,
Marjolein Hoekstra
Posted at 6:20AM on Dec 19th 2005 by Marjolein Hoekstra
Other Weblogs Inc. Network blogs you might be interested in:
1. Can you use ActiveWords to name the VBA events?
Buzz
Posted at 6:20AM on Dec 19th 2005 by Buzz Bruggeman