Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
label colour (MakeAppointmentInOutlook2003)
How can add a "label colour" in this routine?
Sub MakeAppointmentInOutlook2003() Dim olApp As Outlook.Application Dim olApt As AppointmentItem Set olApp = New Outlook.Application Set olApt = olApp.CreateItem(olAppointmentItem) With olApt .Start = Range("A2") .Duration = Range("B2") .Subject = Range("C2") .Location = Range("D2") .Categories = Work .Display .Save End With Set olApt = Nothing Set olApp = Nothing End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
label colour (MakeAppointmentInOutlook2003)
You'd be more likely to get a correct answer by posting in an
Outlook newsgroup. Your question has nothing to do with Excel. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "adropinabucket" wrote in message ... How can add a "label colour" in this routine? Sub MakeAppointmentInOutlook2003() Dim olApp As Outlook.Application Dim olApt As AppointmentItem Set olApp = New Outlook.Application Set olApt = olApp.CreateItem(olAppointmentItem) With olApt .Start = Range("A2") .Duration = Range("B2") .Subject = Range("C2") .Location = Range("D2") .Categories = Work .Display .Save End With Set olApt = Nothing Set olApp = Nothing End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the font for part of an axis label, not the whole label. | Charts and Charting in Excel | |||
ACESS 2003 REPORT LABEL BACKGROUND COLOUR | Excel Discussion (Misc queries) | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions | |||
add text to label (label from forms toolbar) | Excel Programming |