Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Send appointments data to a Form programmatically (http://www.outlookbanter.com/outlook-vba/102306-send-appointments-data-form-programmatically.html)

RogerC May 3rd 10 08:39 PM

Send appointments data to a Form programmatically
 
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 May 4th 10 11:03 AM

Send appointments data to a Form programmatically
 
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" schrieb im Newsbeitrag ...
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?



RogerC May 4th 10 05:29 PM

Send appointments data to a Form programmatically
 
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.


"escamoteur" wrote:

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" schrieb im Newsbeitrag ...
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?


.



All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com