Exporting data from different worksheets to create a new oulook calendar appointment

Hi

I am scratching my head at this one for a while now, I hope someone can help me

I am trying to create a button which will create a new calendar appointment in outlook 2007

The calendar is a shared calendar called "Customer Calendar"

This will be populated with the data that is coming off 2 different worksheets.

Please advise

The data that will be needed is :

Subject : 'order number' - 'company name' (order number is taken from "Input" E4, and the company name from "Input" E5")
Location : 'premises name' (this is taken from "Input" E7

The Date will be taken from "Cover Sheet" H15 (it will be an all day event)

The Body will be standard text - "Openreach engineer booked"

There are no need for any reminders or any flags etc etc.

Does anybody have any ideas that will help, I have looked at the search option on here, but cannot seem to get any of them to work.

Many thanks in advance

Ben

Hi Ben

This code works on my local machine...I have no way to test it on a shared calendar. Try it...let me know of issues.

Please Login or Register  to view this content.

You can save a lot af variables using:

Please Login or Register  to view this content.

NB. If you use 'CreteObject' you won't need a referecne to the outlook library
If you use 'With new outlook' you will.

To put the item directly into the correct calendar: (you only have to adapt the name"common outlook" to your situation)

Please Login or Register  to view this content.