Holiday program - export to ms outlook

is it possible to create an appointment in outlook in excel ?

hi thanks for the reply but this website doesnt work ?

thanks,

ok i've wriiten this code and assinged it to a command button but its highlighting this (olAppointmentItem) as a compile error , cant find project or library ??????

I'm using office 2003.

Please Login or Register  to view this content.

Hello jsmity,

The GetObject function will only attach to a running instance of Outlook. It Outlook isn't running it will error.

I have been working on your workbook. I have added a cell right click menu option to run the macro. This is easier than putting buttons on all the worksheets. Just right click on a cell in column "A" or "B" between rows 20 and 50 and then click "Add Outlook Appointment".

A big problem is with the dates. If the dates are not standardized then you are going to have problems with the appointments. Basically, Outlook only accepts standard date formats. The macro can been altered to handle some custom formats, but sticking with standard dates is better all the way around.

Add Apointment

Please Login or Register  to view this content.

Add and Remove Right Click Menu Item

Please Login or Register  to view this content.

This Workbook Events

Please Login or Register  to view this content.

Sincerely,
Leith Ross

by standard dates what do you mean ?
the date is in the format "Wed 31/Dec/08" which is ddd dd/mm/yy


it highlights this part of the code as an error

Please Login or Register  to view this content.

Hello jsmity,

The date format which you have shown is a custom date format. Outlook will only convert (on its own) date formats that are listed in the Date Type list. I attempted to deal with some of the custom formats, but there is no standardization among the sheets. That why I suggested using only the dates format setup by Windows.

Sincerely, Leith Ross

Thanks , yes i changed all the date formats to one of the standard ones on all the sheets but its still wont work. i tried different date formats ? I've attached the sheet that i edited the date formats can you point in the direction i'm going wrong ?

Hello jsmity,

I revised the macro to accept the date format you have. However, Outlook will still display the dates in the system short date format. For example, if the date is 26-Mar-2008 on the the worksheet, Outlook will enter the appointment date as Wed 3/28/2008. Here is the macro code. This ahs already been changed in the attached workbook.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

just the job working just how i wanted........... thanks