AUTO RUN A MACRO ON OPENING OUTLOOK

[middoabs]

I have written a macro to run a .pps file and would like to know If & How I
can configure Outlook 2003 to automatically run the macro at startup.

 

[Michael Bauer [MVP - Outlook]]

Iin Outlook use the Application_Startup event for that.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 21 May 2008 21:18:00 -0700 schrieb middoabs:

 

[middoabs]

Thank you Michael, but i'm pretty new at this & not sure how to do that.
Could you please elaborate.

Regards.....Peter(middoabs)

 

[Michael Bauer [MVP - Outlook]]

Open the Outlook VBA editor (alt+f11), the n the modul "ThisOutlookSession"
and paste this:

Private Sub Application_Startup()

End Sub

That will be executed on startup if macros are enabled
(Tools/Macros/Security).

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 21 May 2008 23:28:09 -0700 schrieb middoabs:

 

[middoabs]

Thanks Michael, it works a treat.
Regards....middoabs