Outlook appointments

[keri]

I have a db with code that puts appointments I enter from a form (and
save in a table) into the outlook calender. This works fine

However I want to be able to change the label colour on the entry in
the outlook calender. I have looked everywhere for code on how to do
this - and everything I have found I cannot understand nor make work.

ANY(!) help would be appreciated.

Also - if I distribute my database will the new user (on another
computer) have to install the Microsoft Outlook Object Library before
my code to put appointments in outlook will work?

 

[Geoff]

Keri:

However I want to be able to change the label colour on the
entry in the outlook calender.

You'll get a better answer if you post to a newsgroup dedicated to Outlook.

However, AFAIK, it seems you may be out of luck. It appears there is no
Outlook Object Model property equivalent to the Label field. That's what it
says in the following help file in Office XP (Outlook 2002):

C:\Program Files\Microsoft Office\Office10\1033\VBAOL10.chm

This file contains the following topic:

Microsoft Outlook Visual Basic Reference

Microsoft Outlook Forms Reference
Using Visual Basic to Customize Outlook
Using the Outlook Object Model
Outlook fields and their equivalent properties

The above topic lists Outlook fields, but the Label field is missing.

I wondered whether the Label property might be in other object models you
might use - but my hunch is I doubt it. Sue Mosher or Ken Slovak will know.
(They're MVPs who help in the Outlook groups.)

Also - if I distribute my database will the new user (on
another computer) have to install the Microsoft Outlook
Object Library before my code to put appointments in
outlook will work?

If your database creates appointments in a user's Outlook Calendar, then it
seems you know Outlook will be installed on users' machines. If Outlook is
installed, then Outlook's object model should be available. If your database
has a reference to one version of the Outlook Object Model and your users
are running a different version of Outlook, then they may need to adjust the
reference to their version of Outlook and test that your code runs OK on
their machines. (I think Office/Outlook 2003 may adjust automatically.)

As mentioned above, suggest you post to an Outlook newsgroup for better
information.

Geoff