Run external program from Outlook VBA macro

  • Thread starter Marvin Buzz
  • Start date Views 4,655
Status
Not open for further replies.
M

Marvin Buzz

I would like to run an external program from within a macro in Outlook VBA.

I need some sample code to get to the program.

Also, is there a way to have an Outlook macro run each time Outlook is

started?

Thanks.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
1) Depending on the program, the CreateObject function might work for you.

2) See the Application_Startup event.

Best regards

Michael Bauer

Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:


> I would like to run an external program from within a macro in Outlook


VBA.
> I need some sample code to get to the program.

> Also, is there a way to have an Outlook macro run each time Outlook is
> started?

> Thanks.
 
M

Marvin Buzz

Could you provide a sample please?

"Michael Bauer " wrote:



> 1) Depending on the program, the CreateObject function might work for you.

> 2) See the Application_Startup event.

> > Best regards
> Michael Bauer

> > >

> Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:
>
> > I would like to run an external program from within a macro in Outlook

> VBA.
> > I need some sample code to get to the program.
> > Also, is there a way to have an Outlook macro run each time Outlook is
> > started?
> > Thanks.

>
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
For the Application_Startup there's a sample in the VBA help file.

What program do you try to automate, does it offer an object model (like

Outlook, Word etc.) that you can use?

Best regards

Michael Bauer

Am Wed, 7 Oct 2009 06:18:02 -0700 schrieb Marvin Buzz:


> Could you provide a sample please?

> "Michael Bauer " wrote:
>
>

>
>> 1) Depending on the program, the CreateObject function might work for


you.
>

>> 2) See the Application_Startup event.
>

>> > > Best regards
> > Michael Bauer
>

>> >> >>

>

>
>> Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:
> >
> >> I would like to run an external program from within a macro in Outlook

> > VBA.
> >> I need some sample code to get to the program.
> >
>>> Also, is there a way to have an Outlook macro run each time Outlook is
> >> started?
> >
>>> Thanks.

> >
 
M

Marvin Buzz

It is a self-written program written in Visual Basic.

"Michael Bauer " wrote:



> For the Application_Startup there's a sample in the VBA help file.

> What program do you try to automate, does it offer an object model (like
> Outlook, Word etc.) that you can use?

> > Best regards
> Michael Bauer

> > >

> Am Wed, 7 Oct 2009 06:18:02 -0700 schrieb Marvin Buzz:
>
> > Could you provide a sample please?
> > "Michael Bauer " wrote:
> >
> >
> >
> >> 1) Depending on the program, the CreateObject function might work for

> you.
> >
> >> 2) See the Application_Startup event.
> >
> >> > >> Best regards
> >> Michael Bauer
> >
> >> > >> > >>

> >
> >
> >> Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:
> >
> >>> I would like to run an external program from within a macro in Outlook
> >> VBA.
> >>> I need some sample code to get to the program.
> >>
> >>> Also, is there a way to have an Outlook macro run each time Outlook is
> >>> started?
> >>
> >>> Thanks.
> >>

>
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
In VB6 you can have either a COM application with a creatable, public object

(the root object often is called Application), or a standard exe, which can

be launched with the Shell function.

Best regards

Michael Bauer

Am Wed, 7 Oct 2009 11:48:21 -0700 schrieb Marvin Buzz:


> It is a self-written program written in Visual Basic.

> "Michael Bauer " wrote:
>
>

>
>> For the Application_Startup there's a sample in the VBA help file.
>

>> What program do you try to automate, does it offer an object model (like
> > Outlook, Word etc.) that you can use?
>

>> > > Best regards
> > Michael Bauer
>

>> >> >>

>

>
>> Am Wed, 7 Oct 2009 06:18:02 -0700 schrieb Marvin Buzz:
> >
> >> Could you provide a sample please?
> >
>>> "Michael Bauer " wrote:
> >
>>>
>>>
>>>> 1) Depending on the program, the CreateObject function might work for

> > you.
> >>
>>>> 2) See the Application_Startup event.
> >>
>>>> > >>> Best regards
> >>> Michael Bauer
> >>
>>>> >>>> >>>>

> >>
>>>
>>>> Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:
> >>
>>>>> I would like to run an external program from within a macro in Outlook
> >>> VBA.
> >>>> I need some sample code to get to the program.
> >>>
>>>>> Also, is there a way to have an Outlook macro run each time Outlook is
> >>>> started?
> >>>
>>>>> Thanks.
> >>>

> >
 
Status
Not open for further replies.
Top