Hi All,

I have been using the command below to open outlook 2003 (Version
11.8325.8329 SP3), attach a snapshot report, input the Mail address
and input a short message text into the email message.

DoCmd.SendObject acOutputReport, stDocName, acFormatSNP,
vTechSupportEmail, , , "Attached Bug Log Report", vMsgText

Now it will not open Outlook and gives Run-time error '2293'

However, if I open Outlook 2003 first it opens the email message.

Is anyone else experiencing this ?

Windows 7 64Bit
MS Access 2003

Cheers,
Barry

On Dec 8, 3:49*pm, Barry Edmund Wright
<barry.edmund.wri... (AT) witstoronto (DOT) ca> wrote:
Hi All,

I resolved this issue.

I recently installed Avast 5 antivirus and the Avast Outlook plugin
would not let Outlook open.

There are two workarounds for this:
1) Disable the Avast plugin
Open Outlook and go to:
Tools/Options/Other Tab/Advanced Options button/Add-In Manager button/
uncheck Avast
2) Add the following code before the DoCmd.SendObject
'Find out if Outlook is running
If fIsAppRunning("outlook") = False Then
'If outlook is not running then start it.
Shell "outlook.exe", vbNormalNoFocus
End If

fIsAppRunning is an API module I found at the AccessWeb:
API: Find out if an application is currently running
http://www.mvps.org/access/api/api0007.htm

Note: You will need to add the following Case Line to the above module
– it didn’t have one for “Outlook”
Case "Outlook": strClassName = "rctrl_renwnd32"

Cheers,
Barry

sending emails using Access is a joke. move to SQL Server Reporting Services subscriptions if you just want reliable reporting.