Reference to Outlook in ACCESS2007 ??

[Jonath]

Hi,

I'm working with ACCESS2007 on Windows XP and made a form to let the user send an email via OUTLOOK, thanks to FAQ702-2921.

However, I can't find the reference specified in the Emailing posts, which is a reference to Microsoft Outlook.

I tried with references to Microsoft Office, some ActiveX data objects (lots of them...), but it does not work, I still have the error on line:

dim objoutlook as outlook.application

So I guess it's due to the new version of Access?
Does anyone know what the reference to Outlook is?

Thanks in advance,

Jonath

 

[Remou]

Did you look at the references list under Tools in the code Window? You should see something like Microsoft Outlook 11.0 Object Library. You need to tick it.

 

[Jonath]

Hi Remou,

yes I DID look for that reference!! It's not there :-/

Starting with "Microsoft O..." I only have:

Microsoft Office ...
Microsoft OLAP
Microsoft OLE


Starting with "O..", I only have:
OLE DB Errors
OLEPRN
optshold
...

 

[Remou]

It seems as if you may need to re-install Outlook. Have you tried late binding? That is:

[tt]Dim ol As Object

Set ol=CreateObject("Outlook.Application")[/tt]

 

[Jonath]

Additional info:

There is no MSOUTL.OLB file in c:\program files\microsoft office\office12 ..

(I have MSWORD.OLB, MSPPT.OLB, and XL5FR.OLB though...)

 

[Jonath]

Yes, I tried that code, and got an error too.

I am not very interested in re-installin Outlook, do you think it would work if I just copy MSOUTL.OLB on my C: ?

Thanks.