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

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Amok" wrote in message ...
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.