Automation error (apparently) using CreateObject on Outlook - Please help!

[Dave Smithz]

Please help,

All of a sudden I'm getting a problem with associated with opening Outlook
from my Access application (And also using the "View in Outlook" button in
Google Desktop Search).

When it encounters the command:
Set objOutlook = CreateObject("Outlook.application")

It gives the following error:
Run-time error '-2147024770 (8007007e)':
Automation error
The specified module could not be found.

With Google desktop search I used to be able to search for emails and then
press "View in Outlook" and the email would open but now, although it will
open Outlook if not already open it will not actually open the email.

So it would seem some problem with Outlook. A change that I had
recently made were that I installed AVG Free edition Anti Virus which
does install a module for scanning email, but I am not sure if the problem
starting
occurring just after I installed this or not.

Thanks in advance

Kind regards

PS: Apologies for sending to three news groups but I am not sure where to
send this.

 

[Sue Mosher [MVP-Outlook]]

AVG is probably the culprit. I bet it has a script blocker that's blocking the CreateObject("Outlook.Application") call.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba