G
Guest
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
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