By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Creating Object (Outlook.Application)

P: n/a
Greetings.

I am trying to create an instance of Outlook.Application so that I may
build an email within a routine in the VBA behind my database.

I am running MS/Access 2003 (2000 format). The statement that is
failing is:

dim objOutlook as Outlook.Application

The error message is: "User defined type not defined."

I thought that I was missing a library reference, so I enabled
"Microsoft Office Outlook View Control". That didn't work.

Any ideas for me?
Thanks much.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a

"Susan Bricker" <sl*****@verizon.net> wrote in message
news:SG*************@news.uswest.net...
Greetings.

I am trying to create an instance of Outlook.Application so that I may
build an email within a routine in the VBA behind my database.

I am running MS/Access 2003 (2000 format). The statement that is
failing is:

dim objOutlook as Outlook.Application

The error message is: "User defined type not defined."

I thought that I was missing a library reference, so I enabled
"Microsoft Office Outlook View Control". That didn't work.

Any ideas for me?
Thanks much.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***


That's not the library that you need. You need the Microsoft Outlook ##
Object Library. The Office 2003 version is 11.

Randy

Nov 13 '05 #2

P: n/a
Randy,

Thanks for the info. Guess what, though. It didn't work. I added the
reference for Microsoft Office 11.0 Object Library but still get the
error. I then moved it up in the priority list and still got the error.
Then I closed the application and relaunched it (in design mode) and
still got the error (when compiling).

HELP! Any ideas?

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

P: n/a
"Outlook" <> "Office"

Nov 13 '05 #4

P: n/a

"Susan Bricker" <sl*****@verizon.net> wrote in message
news:6O***************@news.uswest.net...
Randy,

Thanks for the info. Guess what, though. It didn't work. I added the reference for Microsoft Office 11.0 Object Library but still get the
error. I then moved it up in the priority list and still got the error. Then I closed the application and relaunched it (in design mode) and
still got the error (when compiling).

HELP! Any ideas?

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***


Susan,

The "Microsoft Office 11.0 Object Library" is not the correct library.

You're looking for the "Microsoft Outlook 11.0 Object Library".

See the text of Randy's post:
That's not the library that you need. You need the Microsoft
Outlook ## Object Library. The Office 2003 version is 11.

Sincerely,

Chris O.
Nov 13 '05 #5

P: n/a
Thanks for the info. When I FINALLY selected the correct library it
worked fine (kept thinking OFFICE not OUTLOOK).

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.