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

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Dave" <(E-Mail Removed)> wrote in message
news:7B62E3BD-0985-47A3-86E4-(E-Mail Removed)...
> 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

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

"Douglas J. Steele" wrote:

> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Dave" <(E-Mail Removed)> wrote in message
> news:7B62E3BD-0985-47A3-86E4-(E-Mail Removed)...
> > 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
>
>
>