"LabelColor" an appointment in Outlook with VBA in Excel.
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. |
"LabelColor" an appointment in Outlook with VBA in Excel.
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. |
"LabelColor" an appointment in Outlook with VBA in Excel.
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. |
"LabelColor" an appointment in Outlook with VBA in Excel.
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. |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com