Controlling Outlook from Excel Using VBA

  • Thread starter Thread starter Trevor Shuttleworth
  • Start date Start date
T

Trevor Shuttleworth

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
 
Back
Top