Import worksheet data to outlook calendar events

I hope someone here can help (as its starting to drive me up the wall)

I have a spreadsheet that I have designed to manage golf societies, from which I would like to be able to enter appointment in outlook calendar.

I have tried the import/export from within Outlook, but a problem I found was when I map custom fields, it reads a date in “dd/mm/yy hh:mm:ss” format.
So even if I mapped the start time to a different column all appointment entered would be at 00:00.

I have seen examples on here and other forums on how this can be done with vba.

So I have the following that I would like to enter as appointments on the calendar, and two other dates as reminders of payments.

Society Name
Date of Booking
1st tee time (start time)

Deposit due date
Balance due date

I would prefer the two due dates to be set as task reminders.

It would also be a benefit to set the duration of the appointment but this would have to be a done as (A1)*7 if that is possible?

Thanks in advance
Jody

Roy,

That site has been very helpful in getting me started.

I am currently experimenting with the code below.

Please Login or Register  to view this content.

But I need to find out how to have it so it does not create a duplicate appointment (subject line) if one already exists. Then for it to repeat the code for multiple rows on a worksheet.

Thanks Jody

Originally Posted by royUK

I'm not sure what you mean, you have coded the cells to get the details from, so Subject will always be C1. Will you have a list of subjects in CDolumn C?

Yes I will have a list that will be added to over the year (up to 50/60). So I will want to be able to add multiple appointments to the calendar every time I run the code, and that is does not create any duplicates.

In the code I posted with cells A1-A4 is just a separate workbook, I am using to test the code and make sure is correct before integrating into the live workbook.