Maybe a little off topic, but can anyone point me at some examples of
controlling Outlook from Excel.

What I want to do is open Outlook (if it is not open) and then connect to
some .pst files.

The reason for wanting to do this is that I file all my emails in .pst files
but the environment in which I work means I have to connect to them every
time I log on and open Outlook. Once the connections are established they
remain until I log out.

Excel VBA is the only tool I have readily available that I think can do
this.

No idea where to look so any web sites, example code or whatever would be
much appreciated.

Thanks

Trevor

Here's a few.
http://www.dicks-clicks.com/excel/olAutomating.htm
http://www.rondebruin.nl/sendmail.htm+

Search Google for 'Automate Outlook with Excel' and I'm sure you'll
find more.

HTH
Paul
-----------------------

On Tue, 9 Sep 2003 21:58:38 +0100, "Trevor Shuttleworth"
wrote:

Maybe a little off topic, but can anyone point me at some examples of
controlling Outlook from Excel.

What I want to do is open Outlook (if it is not open) and then connect to
some .pst files.

The reason for wanting to do this is that I file all my emails in .pst files
but the environment in which I work means I have to connect to them every
time I log on and open Outlook. Once the connections are established they
remain until I log out.

Excel VBA is the only tool I have readily available that I think can do
this.

No idea where to look so any web sites, example code or whatever would be
much appreciated.

Thanks

Trevor