![]() |
|
|
|
#1
|
|||
|
|||
|
May be you can make use of Outlook appointment , and write a little code to activate below code:
Code:
' Set reference to the Outlook library
Sub CreateOutlookAppointment()
Dim objOL As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Set objOL = CreateObject("Outlook.Application")
Set objAppt = objOL.CreateItem(olAppointmentItem)
With objAppt
.Subject = "Sectional Meeting Appointment"
.Location = "Cat's Home"
.ReminderSet = True
.Start = "3/2/2006 10:00:00" 'd/m/yyyy
.End = "3/2/2006 15:00"
'.AllDayEvent = True
.ReminderSet = True
.ReminderMinutesBeforeStart = 30 'Mins
.Save
.display
End With
Set objOL = Nothing
Set objAppt = Nothing
End Sub
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Automatic date updates.
|
WLVanS | Word | 12 | 01-29-2011 04:01 AM |
| Cannot stop the date being printed in the footer | Ubtree | Outlook | 0 | 10-13-2007 11:49 AM |
| new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
| Date format always interpreted as a formula | Butch Jackman | Excel | 1 | 02-14-2006 11:27 AM |
Imported message date change to today's date
|
promark | Outlook | 1 | 12-23-2005 07:21 AM |