there is an excel calendar addin called wincalendar that might help you -
there is also a word template but you might be better off writing a macro to
print the calendar and excel sheet to a pdf (or other electronic format)
then sending them to the duplex printer.

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:




"RogerC" wrote in message
...
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.