How do I create a timesheet weekly from my outlook calendar?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amok - 10 Aug 2006 08:30 GMT

Each week I have to hand in a timesheet. It's just an excel form, but I have
to cut and paste from my outlook Calendar into the cells, and then put in the
hours, and then the project number etc. There MUST be a way to automatically
dump my Outlook appointments from the past week into an excel report form.

Reply to this Message

Sue Mosher [MVP-Outlook] - 11 Aug 2006 02:08 GMT

Copy and paste from a table view might be just the quick-and-dirty solution you need.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Each week I have to hand in a timesheet. It's just an excel form, but I have
> to cut and paste from my outlook Calendar into the cells, and then put in the
> hours, and then the project number etc. There MUST be a way to automatically
> dump my Outlook appointments from the past week into an excel report form.

Reply to this Message

Amok - 11 Aug 2006 03:02 GMT

Thats what we all currently do, but this "quick and dirty solution" still
takes 30 mins for all the little details that we also have to enter. Multiply
by weekly, multiply by 10 people doing timesheets in the department, and I
think we could save quite a bit of time with an automated solution. I'm
actually looking for some automatic script or template document that grabs
the details.
Outlook has an "export" "to Excel Format" function which looks promising,
now I need Excel to open and reformat the data into a timesheet layout.
The question is should this process be an outlook function or an Excel
function?

> Copy and paste from a table view might be just the quick-and-dirty solution you need.
>
> > Each week I have to hand in a timesheet. It's just an excel form, but I have
> > to cut and paste from my outlook Calendar into the cells, and then put in the
> > hours, and then the project number etc. There MUST be a way to automatically
> > dump my Outlook appointments from the past week into an excel report form.

Reply to this Message

Sue Mosher [MVP-Outlook] - 11 Aug 2006 04:05 GMT

It's up to you. The code is largely the same regardless of where you put it. The key difference is how you instantiate the Outlook or Excel Application objects. See http://www.outlookcode.com/d/customprint.htm for links to code samples.

Signature

> Thats what we all currently do, but this "quick and dirty solution" still
> takes 30 mins for all the little details that we also have to enter. Multiply
[quoted text clipped - 13 lines]
>> > hours, and then the project number etc. There MUST be a way to automatically
>> > dump my Outlook appointments from the past week into an excel report form.

Reply to this Message