Hi All,

As the title says I have a workbook embedded in the Outlook appointment form template.

What I would like to do is open the workbook through the current new appointment form and import the Time, Date, Location and Subject fields into cells in the workbook using vba code. I then use this information to set up other external folders using vba but all that works ok.

I have seen other threads about exporting all previous appointment forms into a spreadsheet but cant see a way to modify it for my use.

Any help would be greatly appreciated.