Why use an Outlook Form?

[Stuart Peters]

I have a excel template time sheet that my department uses, when the time
sheet is 40 hours or more and the week is over it will ask if they want to
e-mail it. Then it gets sent to me.
I then take every time sheet I receive and manually enter the totals for
that person into a master time sheet. Manually because I haven't figured out
how to write my code to get the data to automatically grab the file for that
week and put it into my master sheet.

Would there be any advantage to making this timesheet a form in Outlook.
And would it be easier for me to automate if it were a form in outlook?

Note, We all run Office 2003 and Exchange Service 2003.

Thanks in Advance.

Stuart

 

[Sue Mosher [MVP-Outlook]]

No, there would be no advantage. The code would, in fact, be quite a bit more complicated than the Excel VBA code to grab the data and put it in your master sheet. I'd suggest you pursue that solution.

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

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

 

[Hollis D. Paul]

Would there be any advantage to making this timesheet a form in Outlook.
And would it be easier for me to automate if it were a form in outlook?

Probably not. If you don't know how to stuff your date in to the proper
master file in Excel, you won't know how to do it in Outlook, either. And
trying to do formulas in Outlook forms is really not for the faint hearted.
Stick with what works, and learn how to extend that.

Hollis D. Paul [MVP - Outlook]
Mukilteo, WA USA