Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming outlook 2000 from excel
When making an appointment in Outlook 2000 from Excel can you set categories to business or personal for example) or make an appointment private?
-- Regards, DL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
programming outlook 2000 from excel
Sub SetAppointment()
Dim olApp As Outlook.Application Dim olApt As AppointmentItem Set olApp = New Outlook.Application Set olApt = olApp.CreateItem(olAppointmentItem) With olApt .Start = DateSerial(2003, 7, 12) + TimeSerial(10, 0, 0) .End = DateSerial(2003, 7, 12) + TimeSerial(18, 0, 0) .Subject = Range("A2") .Location = Range("B2") .Body = Range("C2") .Categories = "Business" .Sensitivity = olPrivate .BusyStatus = olFree .ReminderMinutesBeforeStart = 240 .ReminderSet = True .Save End With Set olApt = Nothing Set olApp = Nothing End Sub david lindstrom wrote: When making an appointment in Outlook 2000 from Excel can you set categories to business or personal for example) or make an appointment private? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Outlook 2000 Address Book | New Users to Excel | |||
How to send a single page email from excel 2000 using outlook xp | Excel Worksheet Functions | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Excel 2000 Cannot find Outlook 2003 | Setting up and Configuration of Excel | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) |