|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
March 31st 06, 06:08 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Why use an Outlook Form?
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 
|
| Ads |
|
#2
March 31st 06, 06:37 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Why use an Outlook Form?
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Stuart Peters" wrote in message ... 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
|
|
#3
March 31st 06, 08:18 PM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Why use an Outlook Form?
In article ,
=?Utf-8?B?U3R1YXJ0IFBldGVycw==?= wrote: 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| modify outlook form-appointment form | blanc | Outlook and VBA | 1 | March 24th 06 04:20 PM |
| Unable to get enhanced form. Only get the orginal form that was sent | Alex Martinez | Outlook - Using Forms | 9 | March 16th 06 01:28 PM |
| OL2003 - can you auto-fill a singel new contact form with online form data | TimR | Outlook - Using Contacts | 1 | February 15th 06 02:43 PM |
| Outlook opens Form as Email message, not Form | [email protected] | Outlook - General Queries | 2 | January 26th 06 10:54 PM |
| I send an Outlook custom form, but a std. form displays? | Sue Mosher [MVP-Outlook] | Outlook - Using Forms | 0 | January 20th 06 08:41 PM |
Linear Mode
