Error 429 on opening Outlook 2007 from Access 2003

  • Thread starter Thread starter Toots
  • Start date Start date
T

Toots

The following code runs fine from my computer, which is running
Windows XP, Access 2003, Office 2007, . There is no reference set to
Outlook. Other references are set for VB for Application, Access
11.0 , DAO 3.6, OLE Automation, and VB for Applications Extensibility.

Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")


When I try to run the same code on a computer running Windows 7,
Access 2003,Office 2007 I get error 429.

Thanks for your suggestions.
 
Toots said:
The following code runs fine from my computer, which is running
Windows XP, Access 2003, Office 2007, . There is no reference set to
Outlook. Other references are set for VB for Application, Access
11.0 , DAO 3.6, OLE Automation, and VB for Applications Extensibility.

Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")


When I try to run the same code on a computer running Windows 7,
Access 2003,Office 2007 I get error 429.

Thanks for your suggestions.
Click to expand...

Make sure Office 2007 has Service Pack 2 installed. Automating Outlook
has always failed for me without that.
 
Back
Top