PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Form Programming making an appointment in Outlook 2000 from Excel - categories - private

Reply

making an appointment in Outlook 2000 from Excel - categories - private

 
Thread Tools Rate Thread
Old 10-07-2003, 01:38 PM   #1
david lindstrom
Guest
 
Posts: n/a
Default making an appointment in Outlook 2000 from Excel - categories - private


When making an appointment in Outlook 2000 from Excel can you set categories or make an appointment private?


--
Regards,
David Lindstrom

  Reply With Quote
Old 11-07-2003, 07:38 PM   #2
Mirsten Choiple
Guest
 
Posts: n/a
Default Re: making an appointment in Outlook 2000 from Excel - categories - private

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
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off