Print Outlook Calendar with an Excel form on back of same sheet

R

RogerC

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.
 
D

Diane Poremsky [MVP]

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 & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]
 
R

RogerC

Thanks Diane! I think your macro suggestion is the way to go. I assume the
macro would run in Outlook and print the calendar and the Excel sheet as a
single output. Would you know of a good resource where I might learn how to
do this?

Diane Poremsky said:
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 & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]



RogerC said:
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.
.
 
D

Diane Poremsky [MVP]

Start at outlookcode.com - it can run from either outlook or excel,
whichever you are in the most.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]



RogerC said:
Thanks Diane! I think your macro suggestion is the way to go. I assume
the
macro would run in Outlook and print the calendar and the Excel sheet as a
single output. Would you know of a good resource where I might learn how
to
do this?

Diane Poremsky said:
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 & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]



RogerC said:
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.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top