Linking sheets to outlook calendar

[knightmare]

i have a excel sheet with dates of first aiders whom have complete first aid training Im looking to link these dates to my outlook calendar so it pops up as a reminder so i can book them on next years training can this be done if so how?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Im using office 2003 at work and have some basic knowledge of excel and macros <o></o>
<o></o>
<o></o>
<o></o>
many thanks for anyones help <o></o>

 

[JP2112]

If I understand you correctly, you want to push these dates into Outlook with next year's date and have them appear as reminders. Is that correct?

 

[knightmare]

yes mate just not sure if it can be done or how to do it any help would be great


thanks

 

[JP2112]

There are a couple of things you could do here. If you already know when the training is going to be, you could simply send that person a meeting invite for the next year, using the existing date to determine the date of next year's training. Or, you could just create a Task (with a reminder for next year) and you would need to set up the meetings manually at that time.

I don't have code to create meetings, but to create the task reminders, see

http://www.codeforexcelandoutlook.c...xcel-vba-to-set-up-task-reminders-in-outlook/
http://www.codeforexcelandoutlook.com/outlook-vba/create-followup-task-reminders-with-vba/