A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Calendar
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #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.


  #2  
Old June 2nd, 2010, 03:45 AM posted to microsoft.public.outlook.calendaring
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Print Outlook Calendar with an Excel form on back of same sheet

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.


  #3  
Old June 2nd, 2010, 12:00 PM posted to microsoft.public.outlook.calendaring
rogerc
external usenet poster
 
Posts: 50
Default Print Outlook Calendar with an Excel form on back of same shee

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 [MVP]" wrote:

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.


.

  #4  
Old June 2nd, 2010, 02:18 PM posted to microsoft.public.outlook.calendaring
Diane Poremsky [MVP]
external usenet poster
 
Posts: 17,338
Default Print Outlook Calendar with an Excel form on back of same shee

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

--
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
...
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 [MVP]" wrote:

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.


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.