Send appointments data to a Form programmatically

[RogerC]

I need to create a Form that will be printed each morning and used to collect
specific data throughout the day. I would like an area of the Form to
auto-populate with my Outlook Calendar appointments when I open the Form each
day. It does not matter what application is used for the Form... it could
be a Word document, Excel spreadsheet or even a web page, but I would prefer
that it be generated as an output from Outlook.

Basically, I would like to create a highly customized version of the 'Daily
Calendar' Print Style, with my own tables and graphics added to the basic
design. Can this be done programmatically from within Outlook? Does anyone
have any ideas for accomplishing this?

 

[escamoteur]

Sure, this is possible. One of the easiest solutions would be to Excel and retrieve the Outlook Calendar Data with an VBA Makro
script, but you need to know how to program VBA

Best
Tom

 

[RogerC]

Thanks escamoteur!

I was hoping for a solution entirely within Outlook, but I'll look into the
Excel macro possibility. I'm not a VBA programmer by any means, but I have
pieced together macros in Excel in the past. I'll give it a try.