Prev: Monthly Calendar Printing
Next: In MSOfficeOutlook,how to push all calendar entries forward a wee.
From: RogerC on 1 Jun 2010 21:35
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.


From: Diane Poremsky [MVP] on 1 Jun 2010 22:45
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:
mailto:dailytips-subscribe-request(a)lists.outlooktips.net



"RogerC" <RogerC(a)discussions.microsoft.com> wrote in message
news:6628495A-B8F6-4F09-BA06-59A4BE725DC9(a)microsoft.com...
> 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.
>
>
 | 
Pages: 1
Prev: Monthly Calendar Printing
Next: In MSOfficeOutlook,how to push all calendar entries forward a wee.