Calendar appointments in Outlook via VBA

HI
I have found this wonderful piece of code, what i am looking to be able to do is add re ocurring appointments based on the number of weeks in column L. Appointment will always be the same day and time.

Please Login or Register  to view this content.

Thanks Michelle

Hi Solus

Thanks for replying. Column K specifies the number of weeks the appointment is required for at that time. The code i have will book the first date as per column F i would like to book re-curring appointment automatically for the next 4 weeks i.e 16/12/13, 23/12/13, 30/12/13 and the 6/1/14 all for the same time and duration. I have tried to open your attachment but i receive an error message saying the file cannot be found?

Michelle

HI Solus,

thansk again for responding, you kindly helped me out before i remember. I still cant activate the macro, iam receiving an error message stating that the workbook has one or more links that cant be edited, would it be because i cant access a folder you may have created in outlook?

Thanks Solus, Just posted it and it books the first appointment fine but not the following 4 re - ocurring?

Michelle

Actually Solus i have just seen what its doing. The occurrance should be weekly for 4 weeks but its set it for every 4 weeks.

Solus you are a genius, thanks so much for helping me out, it works perfectly.

Michelle