|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
October 25th 06, 11:52 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
In Visual Basic, how do I access the Calendar Label color for appt
In Outlook 2003, using VisualBasic in a macro.
I'm downloading appointments (including date, time, and duration) into Excel for analysis. I've modified the Outlook appointment Calendar Color Labels to tag appointments as specific types of appointments. I'd like to download the color labels (or better yet, the text for each label) to categorize the appointments for analysis. I cannot determine where the appointment "Calendar Color Label" property is stored for AppointmentItems, and if it is accessible from Visual Basic in a macro. 
|
| Ads |
|
#2
October 26th 06, 12:11 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
In Visual Basic, how do I access the Calendar Label color for appt
It's available only with low-level interfaces like CDO 1.21 and Redemption. See:
http://www.outlookcode.com/codedetail.aspx?id=823 http://www.outlookcode.com/codedetail.aspx?id=763 -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "D2SRJ" wrote in message ... In Outlook 2003, using VisualBasic in a macro. I'm downloading appointments (including date, time, and duration) into Excel for analysis. I've modified the Outlook appointment Calendar Color Labels to tag appointments as specific types of appointments. I'd like to download the color labels (or better yet, the text for each label) to categorize the appointments for analysis. I cannot determine where the appointment "Calendar Color Label" property is stored for AppointmentItems, and if it is accessible from Visual Basic in a macro.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| adding a new color label to the label list for Microsoft Outlook 2 | CSS Tech | Outlook - Calandaring | 1 | July 21st 06 04:57 PM |
| MS Visual Basic error in Outlook | XP User | Outlook - General Queries | 3 | May 7th 06 12:45 PM |
| Visual Basic and OE | [email protected] | Outlook Express | 1 | February 8th 06 01:35 PM |
| Visual Basic Editor opens automatically | [email protected] | Outlook - General Queries | 0 | February 6th 06 04:54 PM |
| Visual Basic Editor opens automatically | [email protected] | Outlook and VBA | 0 | February 6th 06 04:53 PM |
Linear Mode
