AUTO RUN A MACRO ON OPENING OUTLOOK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

middoabs - 22 May 2008 05:18 GMT

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.

Reply to this Message

Michael Bauer [MVP - Outlook] - 22 May 2008 07:09 GMT

Iin Outlook use the Application_Startup event for that.

Signature

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:

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

Reply to this Message

middoabs - 22 May 2008 07:28 GMT

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

Regards.....Peter(middoabs)

> Iin Outlook use the Application_Startup event for that.
>
> > 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.

Reply to this Message

Michael Bauer [MVP - Outlook] - 22 May 2008 19:11 GMT

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

Signature

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:

> Thank you Michael, but i'm pretty new at this & not sure how to do that.
> Could you please elaborate.
[quoted text clipped - 6 lines]
>> I
>>> can configure Outlook 2003 to automatically run the macro at startup.

Reply to this Message

middoabs - 25 May 2008 22:56 GMT

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

> Open the Outlook VBA editor (alt+f11), the n the modul "ThisOutlookSession"
> and paste this:
[quoted text clipped - 17 lines]
> >> I
> >>> can configure Outlook 2003 to automatically run the macro at startup.

Reply to this Message