View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Controlling Outlook from Excel Using VBA

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