Every week my boss asks his employees (about 6 people) to write a Weekly Summary report about what they did that week. They are to include What they did and an estimate of the time it took for each task. All of the employees email their Weekly Summary in a different format, and my boss has to combine all of the reports and format them accordingly, which usually takes him 20min. He wants me to create a database that will format these e-mails uniformly. I started the project to open then e-mail and search for bullets to start formatting text, but then I realized everyone uses different kinds of bullets and different formatting. What approach do you guys think I should do to tackle this project? (my boss doesn't want to tell everyone to use the same format and he doesnt want them to input anything directly into the database)
Format E-mail Project
- Thread starter kidrobot
- Start date
DCrake
Remembered
- Local time
- Today, 04:55
- Joined
- Jun 8, 2005
- Messages
- 8,623
Simple Software Solutions
Create a Word Template and distribute this to the employees requesting that they complete it and Email the template to the you/boss. You/He can then extract the data from known bookmarks.
CodeMaster:
Create a Word Template and distribute this to the employees requesting that they complete it and Email the template to the you/boss. You/He can then extract the data from known bookmarks.
CodeMaster:
georgedwilkinson
AWF VIP
- Local time
- Yesterday, 22:55
- Joined
- Mar 4, 2008
- Messages
- 3,826
Create a table with a memo field. Bind a RTF control to the memo field.
When the field is updated, strip out all user formatting and leave just text.
Insist that the users only write one line in the database per detail item in their "report".
Give your boss an Access report that pulls data from the table with the memo field...format the data into a uniform look and feel at this point.
Have the boss wrap the knuckles of anyone who doesn't comply.
Lots and lots of work (i.e. billable hours and/or job security).
When the field is updated, strip out all user formatting and leave just text.
Insist that the users only write one line in the database per detail item in their "report".
Give your boss an Access report that pulls data from the table with the memo field...format the data into a uniform look and feel at this point.
Have the boss wrap the knuckles of anyone who doesn't comply.
Lots and lots of work (i.e. billable hours and/or job security).
DCrake
Remembered
- Local time
- Today, 04:55
- Joined
- Jun 8, 2005
- Messages
- 8,623
Simple Software Solutions
If you really want to impress your boss the way to do this is to create a form whilst in Word using VBE and attach this to each users menu. The then call this form to enter data against specific prompts and when each user selects Save you code it save it in an Access database table, which he can then analyse.
CodeMaster:
If you really want to impress your boss the way to do this is to create a form whilst in Word using VBE and attach this to each users menu. The then call this form to enter data against specific prompts and when each user selects Save you code it save it in an Access database table, which he can then analyse.
CodeMaster:
