Outlook '03 automation from Access '03 error
I am running into problems with creating a new outlook session where i get the error message:
Run-time error '-2147024770 (8007007e)':
The specified module could not be found.
I have the Reference box checked for 'Microsoft Outlook 11.0 Object Library'
I have this declared at beginning:
Dim objOutlook As Outlook.Application
Set objOutlook = CreateObject("Outlook.Application")
when it hits this line i get the error message. I tried changing the outlook to Excel and it works fine, firing up excel with it made visible.
Outlook works fine manually openign it, and is installed on the machine.
ive been reading around and read that this may be caused by 'not having the full version of Access installed'
Can anyone help please? any advice and suggestions would mostly be appreciated. Thank you for your time and help.