Check for Outlook instance

[Dave]

Hi all,
I have an email report button on one of my forms which creates a snapshot
report and sends it off to the required recipients. I need some code to run
before the report code to check to see if Outlook is open and if not, open
it. I imagine the code would be something like:

if not isopen(outlook.exe) then
Shell ("C:\Program Files\Microsoft Office2k\Office\outlook.exe")
end if

Can anyone supply the correct code??

Thanks in advance
Dave

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/api/api0007.htm at "The Access
Web"

If you don't know the class name for Outlook, take a look at
http://www.mvps.org/access/api/api0013.htm while you're there.

 

[Dave]

Thanks Douglas.
That stuff was gold.
Great site.
Cheers
Dave