outlook open or not??????

[paulmcdonnell]

Hi guys

My application uses outlook heavily. To the point now where my application only works effectively if outlook is open and running.

I want to be able to open outlook when i start my application.

I can do this using the shell command but I open a new instance of outlook each time i do this.

How can i check to see if outlook is open before i need my db to openit it's self.

I thougt of just switching to outlook temporarily and if an error should occur then open outlook from the db.

Now could i do this,I'm not sure of the code. But is there a better way that isn't too complex

Hope you guys can help

Cheers
Paul

 

[Fuga]

Rather primitive solution

This is how I do it. Admittedly, it is not very elegant so if anyone knows a better way, I too would be very interested.

on error goto myerror

interaction.appactivate ("name of outlook window")
**some code**

myerror:
**your code including the shell...**

Fuga.

 

[paulmcdonnell]

cheers fuga,

Still doesn't quite work the way I want it to.


Outlook when opened in the shell method, even if i use ,vbhide or , vbminimizenofocus in the expression, remains as the focused application. How do I revert back to my database?

anyone know?
Cheers
Paul