|
| 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
May 20th 06, 12:20 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
appointment colours
I can write fairly simple code in VB6 and have used VBA for MS Word but
have never used VBA in outlook At work we have to code appointments in calendar by workplan codes by setting the background colours provided in label. What I need to do is make a macro that searches all the appointments and counts those that have a given background colour Any ideas welcome Jaez 
|
|
#2
May 20th 06, 09:14 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
appointment colours
Am Fri, 19 May 2006 22:20:47 GMT schrieb Jaez:
This sample might give you a starting point: http://www.outlookcode.com/codedetail.aspx?id=755 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- I can write fairly simple code in VB6 and have used VBA for MS Word but have never used VBA in outlook At work we have to code appointments in calendar by workplan codes by setting the background colours provided in label. What I need to do is make a macro that searches all the appointments and counts those that have a given background colour Any ideas welcome Jaez
|
|
#3
May 20th 06, 06:25 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
appointment colours
Thanks Michael
I created a new form in Outlook calendar and added a button pasted the code from the site you suggested and linked the button to I then get the error in the function on the line marked ***** Compile error -User defined type not defined Function GetCalendarLabels(objFolder As Outlook.MAPIFolder) As String ' returns labels as semicolon-delimited string ***** Dim cdoSession As MAPI.Session Dim cdoFolder As MAPI.Folder Dim cdoField As MAPI.Field Dim strLabels As String Dim strLabelName As String Any ideas If this works it would seem to list the labels that the user has entered What I need is to be able to find the label associated with an appointment objAppt.Subject gives me the subject and objAppt.start gives me the start time but nowhere can I find the equivalent of objAppt.label Even exporting the Calendar into outlook does not seem to export the labels Jaez "Michael Bauer" wrote in message ... Am Fri, 19 May 2006 22:20:47 GMT schrieb Jaez: This sample might give you a starting point: http://www.outlookcode.com/codedetail.aspx?id=755 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- I can write fairly simple code in VB6 and have used VBA for MS Word but have never used VBA in outlook At work we have to code appointments in calendar by workplan codes by setting the background colours provided in label. What I need to do is make a macro that searches all the appointments and counts those that have a given background colour Any ideas welcome Jaez
|
|
#4
May 21st 06, 01:36 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
appointment colours
Am Sat, 20 May 2006 16:25:28 GMT schrieb Jaez:
Then you need to add a ref onto that library to your project via Tools/References. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Thanks Michael I created a new form in Outlook calendar and added a button pasted the code from the site you suggested and linked the button to I then get the error in the function on the line marked ***** Compile error -User defined type not defined Function GetCalendarLabels(objFolder As Outlook.MAPIFolder) As String ' returns labels as semicolon-delimited string ***** Dim cdoSession As MAPI.Session Dim cdoFolder As MAPI.Folder Dim cdoField As MAPI.Field Dim strLabels As String Dim strLabelName As String Any ideas If this works it would seem to list the labels that the user has entered What I need is to be able to find the label associated with an appointment objAppt.Subject gives me the subject and objAppt.start gives me the start time but nowhere can I find the equivalent of objAppt.label Even exporting the Calendar into outlook does not seem to export the labels Jaez "Michael Bauer" wrote in message ... Am Fri, 19 May 2006 22:20:47 GMT schrieb Jaez: This sample might give you a starting point: http://www.outlookcode.com/codedetail.aspx?id=755 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- I can write fairly simple code in VB6 and have used VBA for MS Word but have never used VBA in outlook At work we have to code appointments in calendar by workplan codes by setting the background colours provided in label. What I need to do is make a macro that searches all the appointments and counts those that have a given background colour Any ideas welcome Jaez
|
|
#5
May 21st 06, 02:07 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
appointment colours
Looking again I see I added wrong one cdo ref What I need now is to be able to find the label associated with an appointment - any ideas - objAppt.Subject gives me the subject and objAppt.start gives me the start time but nowhere can I find the equivalent of objAppt.label Jaez "Michael Bauer" wrote in message ... Am Sat, 20 May 2006 16:25:28 GMT schrieb Jaez: Then you need to add a ref onto that library to your project via Tools/References. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Thanks Michael I created a new form in Outlook calendar and added a button pasted the code from the site you suggested and linked the button to I then get the error in the function on the line marked ***** Compile error -User defined type not defined Function GetCalendarLabels(objFolder As Outlook.MAPIFolder) As String ' returns labels as semicolon-delimited string ***** Dim cdoSession As MAPI.Session Dim cdoFolder As MAPI.Folder Dim cdoField As MAPI.Field Dim strLabels As String Dim strLabelName As String Any ideas If this works it would seem to list the labels that the user has entered What I need is to be able to find the label associated with an appointment objAppt.Subject gives me the subject and objAppt.start gives me the start time but nowhere can I find the equivalent of objAppt.label Even exporting the Calendar into outlook does not seem to export the labels Jaez "Michael Bauer" wrote in message ... Am Fri, 19 May 2006 22:20:47 GMT schrieb Jaez: This sample might give you a starting point: http://www.outlookcode.com/codedetail.aspx?id=755 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- I can write fairly simple code in VB6 and have used VBA for MS Word but have never used VBA in outlook At work we have to code appointments in calendar by workplan codes by setting the background colours provided in label. What I need to do is make a macro that searches all the appointments and counts those that have a given background colour Any ideas welcome Jaez
|
|
#6
May 22nd 06, 06:43 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
appointment colours
Am Sun, 21 May 2006 12:07:37 GMT schrieb Jaez:
Please follow the second comment from Sue under the mentioned sample. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Looking again I see I added wrong one cdo ref What I need now is to be able to find the label associated with an appointment - any ideas - objAppt.Subject gives me the subject and objAppt.start gives me the start time but nowhere can I find the equivalent of objAppt.label Jaez "Michael Bauer" wrote in message ... Am Sat, 20 May 2006 16:25:28 GMT schrieb Jaez: Then you need to add a ref onto that library to your project via Tools/References. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- Thanks Michael I created a new form in Outlook calendar and added a button pasted the code from the site you suggested and linked the button to I then get the error in the function on the line marked ***** Compile error -User defined type not defined Function GetCalendarLabels(objFolder As Outlook.MAPIFolder) As String ' returns labels as semicolon-delimited string ***** Dim cdoSession As MAPI.Session Dim cdoFolder As MAPI.Folder Dim cdoField As MAPI.Field Dim strLabels As String Dim strLabelName As String Any ideas If this works it would seem to list the labels that the user has entered What I need is to be able to find the label associated with an appointment objAppt.Subject gives me the subject and objAppt.start gives me the start time but nowhere can I find the equivalent of objAppt.label Even exporting the Calendar into outlook does not seem to export the labels Jaez "Michael Bauer" wrote in message ... Am Fri, 19 May 2006 22:20:47 GMT schrieb Jaez: This sample might give you a starting point: http://www.outlookcode.com/codedetail.aspx?id=755 -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- I can write fairly simple code in VB6 and have used VBA for MS Word but have never used VBA in outlook At work we have to code appointments in calendar by workplan codes by setting the background colours provided in label. What I need to do is make a macro that searches all the appointments and counts those that have a given background colour Any ideas welcome Jaez
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why are the label colours in my Outlook 2003 calendar never displ. | Siskin | Outlook - Calandaring | 0 | April 7th 06 11:20 PM |
| Shared Calendar Colours | Tanya | Outlook - Calandaring | 1 | April 5th 06 05:38 AM |
| Recurring appointment/events linked to other recurring appointment | uaewhitey | Outlook - Calandaring | 0 | February 2nd 06 08:55 PM |
| syncing attachments/colours with contact file | carolgouveia | Outlook - Using Contacts | 0 | January 25th 06 03:19 PM |
| Outlook 2000 assign colours to a Catagory | dawogette | Outlook - Calandaring | 0 | January 25th 06 09:25 AM |
Hybrid Mode
