LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to create outlook appointment Dan Wood Excel Discussion (Misc queries) 2 March 4th 10 01:31 PM
outlook appointment labels colour from excel Brettjg Excel Discussion (Misc queries) 2 March 9th 08 06:00 AM
Adding an Outlook appointment shortcut to the Excel menu Creating a Word shortcut in Excel[_2_] Excel Discussion (Misc queries) 1 December 7th 07 06:33 PM
Pass a time value from Excel to Outlook appointment splodgey Excel Discussion (Misc queries) 2 October 18th 07 11:17 AM
Create a button in excel that can open an outlook appointment? Movieman Excel Worksheet Functions 1 July 15th 05 12:20 AM


All times are GMT +1. The time now is 03:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"