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

[Guest]

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.

 

[Sue Mosher [MVP-Outlook]]

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

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?

 

[Sue Mosher [MVP-Outlook]]

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.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers