View Single Post
  #1  
Old June 2nd, 2010, 02:35 AM posted to microsoft.public.outlook.calendaring
rogerc
external usenet poster
 
Posts: 50
Default Print Outlook Calendar with an Excel form on back of same sheet

I work for a large company where all employees print two forms everyday. One
is their Outlook calendar and the other is an Excel Form used to collect data
during the completion of a daily process throughout the day.

I would like to automate the printing of these two forms by combining them
into a single print function with the output resulting in their Outlook
Calendar Daily View on the front and the data collection Form on the back of
a single sheet.

I've tried exporting my calendar data into a sheet in the Excel workbook,
but formatting the schedule data to look graphically like an Outlook calendar
is not working well for me.

At this point, I'm looking for suggestions on what would be the best
strategy for accomplishing this. Ideally, the combined printed output would
be automatic when the user prints their Daily Calendar.

Although the Excel Form is already developed and in use, I am open to
re-creating it as some other sort of form if needed for this printing
scenerio. It's in Excel now because the users need to occasionally edit the
form elements.