Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 295
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 295
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding an Outlook appointment shortcut to the Excel menu Creating a Word shortcut in Excel[_2_] Excel Discussion (Misc queries) 1 December 7th 07 06:33 PM
Pass a time value from Excel to Outlook appointment splodgey Excel Discussion (Misc queries) 2 October 18th 07 11:17 AM
Automatically create outlook appointment Alarmbloke Excel Discussion (Misc queries) 0 March 12th 06 08:47 PM
Best program for address book w/email and print labels? Outlook? pccheryle Excel Discussion (Misc queries) 0 December 7th 05 05:35 PM
Create a button in excel that can open an outlook appointment? Movieman Excel Worksheet Functions 1 July 15th 05 12:20 AM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"