Prev: Two different organizers in one meting
Next: Viewing Calendar Entries as a List
From: RogerC on 2 Jun 2010 07:00
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:
> 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.
> >
> >
> .
>
From: Diane Poremsky [MVP] on 2 Jun 2010 09:18
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:
mailto:dailytips-subscribe-request(a)lists.outlooktips.net



"RogerC" <RogerC(a)discussions.microsoft.com> wrote in message
news:AF1983EA-214C-4B1F-A888-24F6858AB927(a)microsoft.com...
> 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:
>> 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: Two different organizers in one meting
Next: Viewing Calendar Entries as a List