Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook Appointment object - yearly recurring (i.e. anniversary)

Status
Not open for further replies.

HuronBaloo

Programmer
Mar 25, 2024
1
CA
So...

Having a time trying to create anniversary/birthday entries in Outlook with yearly recurrence using VBScript. They become daily All Day entries even though I specify olRecursYearly. I even tried using the value "5" instead. Not quite sure how to get around this. Other settings such as Category work just fine.

Here's the code:
---------
Const olAppointmentItem = 1
set objoutlook = createobject("outlook.application")
set objnspace = objoutlook.GetNameSpace("MAPI")
BDDate = "6/15/1958"
While BDDate <> ""
If BDDate <> "6/15/1958" Then
BDName = InputBox("What are we celebrating?", "Add Birthdays Script")
BDMessage = InputBox("Additional Information?", "Add Birthdays Script")
AddBirthday
End If
BDDate = InputBox("Enter Date in 6/15/1958 format", "Add Birthdays Script", "")
WEnd
set objoutlook = Nothing
set objnspace = Nothing
Sub AddBirthday
set objAppointment = objoutlook.createitem(olAppointmentItem)
objAppointment.Start = BDDate
objAppointment.Subject = BDName
objAppointment.Body = BDMessage
objAppointment.AllDayEvent = True
objAppointment.ReminderMinutesBeforeStart = 15
objAppointment.ReminderSet = True
objAppointment.Categories = "Birthday/Anniversary"
set objRecurrence = objAppointment.GetRecurrencePattern
objRecurrence.RecurrenceType = olRecursYearly
' objRecurrence.RecurrenceType = 5
objRecurrence.PatternStartDate = #05/16/1983#
objRecurrence.NoEndDate = True
objAppointment.Save
set objAppointment = Nothing
set objRecurrence = Nothing
End Sub
------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top