Accessing Outlook Resources from Within Access

[grep]

I'd like to write an Access app that can use some of the functionality
of Outlook. I'd like to be able to read/write information to my Outlook
contacts, and perhaps be able to schedule appts. right from my Access
app. How could I do this? Is there an API or something I could tap into
to gain access to the controls?

Thanks,

grep

 

[Dan Artuso]

Hi,
You can automate Outlook by using it's library.
All you have to do is set a reference to this library in Access.

That's the short answer. You have to get familiar with the it's object model
to be able to use it effectively.

To get an idea, once you set a reference to it, open the object browser
and take a look at it.

To set a reference, with any code module open, go to:
Tools->References
and check off Microsoft Outlook .....

Then press F8 (to open the Object Browser).

 

[grep]

Dan,

Perfect. Thanks for edjimcating me about the references. There's a lot
of really cool stuff in there! Next question is, what resources are
available out there (besides this one and Help) to help me better learn
and understand how to use them?

grep

 

[Dan Artuso]

Hi,
For Outlook stuff, this is a good one:
http://slipstick.com

For any Office product automation, the newsgroups are your best bet.