Dear all;

Bob Phillips helped me a few days ago by giving me code to create an outlook
appointment with VBA in Excel.
Bob; it works !!

What misses is the option to give the appointment a "labelcolor".
(As in right-clicking an appointment \ Label | Color )

Is that possible with VBA.
I looked in all the properties but could not find it.
Mark.

Mark,

What version of Outlook is this? I can't see it in my version (OL2000) as an
option at all.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Rosenkrantz" wrote in message
...
Dear all;

Bob Phillips helped me a few days ago by giving me code to create an
outlook
appointment with VBA in Excel.
Bob; it works !!

What misses is the option to give the appointment a "labelcolor".
(As in right-clicking an appointment \ Label | Color )

Is that possible with VBA.
I looked in all the properties but could not find it.
Mark.

Bob;

I work with the English version of Outlook 2002.
Office XP.
I could not find it either.

Mark.

"Bob Phillips" wrote in message
...
Mark,

What version of Outlook is this? I can't see it in my version (OL2000) as
an
option at all.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Rosenkrantz" wrote in message
...
Dear all;

Bob Phillips helped me a few days ago by giving me code to create an
outlook
appointment with VBA in Excel.
Bob; it works !!

What misses is the option to give the appointment a "labelcolor".
(As in right-clicking an appointment \ Label | Color )

Is that possible with VBA.
I looked in all the properties but could not find it.
Mark.

Mark,

I have cracked it. Do you still need it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Rosenkrantz" wrote in message
...
Bob;

I work with the English version of Outlook 2002.
Office XP.
I could not find it either.

Mark.

"Bob Phillips" wrote in message
...
Mark,

What version of Outlook is this? I can't see it in my version (OL2000)
as
an
option at all.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mark Rosenkrantz" wrote in message
...
Dear all;

Bob Phillips helped me a few days ago by giving me code to create an
outlook
appointment with VBA in Excel.
Bob; it works !!

What misses is the option to give the appointment a "labelcolor".
(As in right-clicking an appointment \ Label | Color )

Is that possible with VBA.
I looked in all the properties but could not find it.
Mark.