Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make appointment in outlook using data in excel -- set recurrence
make appointment in outlook using data in excel
In this macro how do I sent the reccurence to the same day every year? Sub SetAppointment() Dim olApp As Outlook.Application Dim olApt As AppointmentItem Set olApp = New Outlook.Application Set olApt = olApp.CreateItem(olAppointmentItem) With olApt .AllDayEvent = True .Start = Range("B2") 'date of birth .Subject = Range("A2") 'family member's name .Categories = "Personal" .BusyStatus = olFree .ReminderSet = True .ReminderMinutesBeforeStart = 240 .Save End With Set olApt = Nothing Set olApp = Nothing End Sub -- Regards, DL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to create outlook appointment | Excel Discussion (Misc queries) | |||
outlook appointment labels colour from excel | Excel Discussion (Misc queries) | |||
Adding an Outlook appointment shortcut to the Excel menu | Excel Discussion (Misc queries) | |||
Pass a time value from Excel to Outlook appointment | Excel Discussion (Misc queries) | |||
Create a button in excel that can open an outlook appointment? | Excel Worksheet Functions |