outlook 2007 automation from Access

[phleduc]

I have mulitple office versions installed (Access 97, 2000, 2003, Office
2003, Office 2007)
Unitl recently automation to Outlook from Access worked (in Access 2003)
However something (update, installation of visio, project 2003,...?????)
created an issue.
Any of my code trying to create the outlook object gives the following kind
of error: "automation error, the specified module could not be found"
The reference is set to "C:\Program Files\Microsoft
Office\Office12\MSOUTL.OLB", this file is still there?
Is there any way to register this file again or to solve it otherwise. I
read somewhere that a reinstall of office might be necessary which could be
a complete nightmare as i have all thise different versions. Could I just
install and reinstall Outllook?

Thx

Philip

 

[Sue Mosher [MVP-Outlook]]

Have you tried using Tools | References to remove the reference to Outlook and then restore it? You can also run Office Diagnostics to repair Outlook 2007.

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

 

[phleduc]

tried tools references/remove outlook reference/compact repair database,
reestablish, no difference...
click on the installation files, did a repair of office 2007, no
difference...
even grabbed the file from another computer, replaced it, still no
difference...

I actually forgot but also recently installed groove 2007 on this machine,
would that make a difference?

THX

philip


Have you tried using Tools | References to remove the reference to Outlook
and then restore it? You can also run Office Diagnostics to repair Outlook
2007.

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

 

[Sue Mosher [MVP-Outlook]]

Does code in Outlook 2007 VBA run at all? Does late binding in Access work?

I don't know of any difference that Groove would make.

 

[phleduc]

yep, the code used to run till a couple of weeks ago.. am not sure when I
last used one of the features.
the only reason I see why (installation of) groove 2007, project 2003 or
visio 2003 could make a difference is that they are office components and
could as such reset certain "office" parameters.
I know this sounds like a wild guess but perhaps installing another office
2007 component would reset that switch again????

Does code in Outlook 2007 VBA run at all? Does late binding in Access work?

I don't know of any difference that Groove would make.

 

[Sue Mosher [MVP-Outlook]]

I'm not sure you answered my first two questions, so let me rephrase them:

1) If you write a simple macro in Outlook VBA, does it run OK?

2) If you modify your Access code to use only late-bound Outlook objects, does that solve the problem?

You could always try removing and reinstalling Outlook 2007.

 

[phleduc]

Hi Sue,
I am on vacation in Europe right now but will try your suggestions on my
return second half of July,
(or earlier if I see an opportunity between visiting friends and family)

Thx

Philip

I'm not sure you answered my first two questions, so let me rephrase them:

1) If you write a simple macro in Outlook VBA, does it run OK?

2) If you modify your Access code to use only late-bound Outlook objects,
does that solve the problem?

You could always try removing and reinstalling Outlook 2007.