outlook appointment labels colour from excel
 

Hello out there, I'm using Office 2003 and successfully creating Outlook
appointments from Excel. Some of the parameters that I set are as follows:

.ReminderMinutesBeforeStart = 0
.ReminderSet = True

Is there a parameter that I can set to put a coloured label on the
appointment? I've had a look in VBA parameters and nothing shows up, so I'm
not hopeful!
Regards, Brett Gregory

outlook appointment labels colour from excel
 

I know that you are looking for the Label. Perhaps if you were to select
..Label = Important, that may change the appointment to red.

"Brettjg" wrote:

Hello out there, I'm using Office 2003 and successfully creating Outlook
appointments from Excel. Some of the parameters that I set are as follows:

.ReminderMinutesBeforeStart = 0
.ReminderSet = True

Is there a parameter that I can set to put a coloured label on the
appointment? I've had a look in VBA parameters and nothing shows up, so I'm
not hopeful!
Regards, Brett Gregory

outlook appointment labels colour from excel
 

Thanks Sean, but it doesn't work. If I right click over the ".Label" the are
no options for label, which is why I think there may be no solution to this.

"Sean Timmons" wrote:

I know that you are looking for the Label. Perhaps if you were to select
.Label = Important, that may change the appointment to red.

"Brettjg" wrote:

Hello out there, I'm using Office 2003 and successfully creating Outlook
appointments from Excel. Some of the parameters that I set are as follows:

.ReminderMinutesBeforeStart = 0
.ReminderSet = True

Is there a parameter that I can set to put a coloured label on the
appointment? I've had a look in VBA parameters and nothing shows up, so I'm
not hopeful!
Regards, Brett Gregory