|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
June 22nd 07, 06:14 PM
posted to microsoft.public.outlook
|
|||
|
|||
outlook 2007 automation from Access
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 
|
|
#2
June 22nd 07, 06:55 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
outlook 2007 automation from Access
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/comm....program_v ba -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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
|
|
#3
June 22nd 07, 07:16 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
outlook 2007 automation from Access
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 "Sue Mosher [MVP-Outlook]" wrote in message ... 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/comm....program_v ba -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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
|
|
#4
June 22nd 07, 08:13 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
outlook 2007 automation from Access
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, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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? "Sue Mosher [MVP-Outlook]" wrote in message ... 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/comm....program_v ba -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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
|
|
#5
June 22nd 07, 08:32 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
outlook 2007 automation from Access
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???? "Sue Mosher [MVP-Outlook]" wrote in message ... 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, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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? "Sue Mosher [MVP-Outlook]" wrote in message ... 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/comm....program_v ba -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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
|
|
#6
June 22nd 07, 09:24 PM
posted to microsoft.public.outlook
|
|||
|
|||
|
outlook 2007 automation from Access
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. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "phleduc" wrote in message ... 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???? "Sue Mosher [MVP-Outlook]" wrote in message ... 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" wrote in message ... 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? "Sue Mosher [MVP-Outlook]" wrote in message ... 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. "phleduc" wrote in message ... 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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook automation Server 2007 | J. Resperger | Outlook and VBA | 0 | February 20th 07 08:43 AM |
| automation with outlook 2007 compared with earlier versions | Philip Leduc | Outlook - General Queries | 1 | February 16th 07 11:45 PM |
| Outlook Automation | Tylendal | Outlook and VBA | 3 | April 24th 06 02:39 PM |
| Outlook automation using vbs | Marceepoo | Outlook - Installation | 1 | January 17th 06 04:18 AM |
| Help on Outlook automation | Neo | Outlook - General Queries | 1 | January 15th 06 04:49 PM |
Hybrid Mode
