Create appointment not email from data

[ianh]

I have used data in excel previously in automated emails.

Please Login or Register  to view this content.

instead of creating an email item i would like to create an appointment in the calender. Googleing points me in the direction of using

Please Login or Register  to view this content.

But i cant seem to get it right. Any ideas?

Not sure if this should be in excel or outlook area of the forum, so sorry Mod's if it is in the wrong place.

[ianh]

Just found this http://www.excelforum.com/excel-prog...excel-vba.html

ideally i want to set recurrence and end date, as well as removing the reminder.