Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing detailed Tasks list (2003)

    Using tasks we would like to be able to print off a task list that clearly shows the task title, task description in full, if the task has been assigned to anyone and the start date and due date. I have tried most of the views and when I print off the list
    Neil Eustice
    Woody Worshipper

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Printing detailed Tasks list (2003)

    The built-in printing layouts can be pretty limited. For calendars, there are suggestions and add-ins at http://www.slipstick.com/calendar/index.htm#print. They might have something for task lists, too.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Watford, Hertfordshire, England
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing detailed Tasks list (2003)

    Thanks for the link but unfortunately nothing there to help with this specific problem.

    Neil
    Neil Eustice
    Woody Worshipper

  4. #4
    Lounger
    Join Date
    Jan 2004
    Location
    Honolulu, Hawaii, USA
    Posts
    47
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing detailed Tasks list (2003)

    Isn't that frustrating?
    It can be done with code. The real question is how important are looks and how far are you willing to go?
    The most flexible way would be to use MS Access.
    My current client hired me to do it with Excel.
    However Excel requires some skill in creating "reports". You need to understand how to format stuff.
    What I'm looking for is some theoretical construct for organizing tasks. For me a task is not just "Call back client XYZ" or "Ship order 3278943". It is more like "Develop a strategy for improving the livability of your community".

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Printing detailed Tasks list (2003)

    > "Develop a strategy for improving the livability of your community"

    Wow, that would take a little while. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    I worked on something a long, long time ago that was a database application which allowed for an "outline-like" hierarchy from goals and projects down to "to do" items. I never finished it... but anyway, Excel is a faster and more intuitive way to prototype a hierarchical relationship than a database tool. It just requires more discipline to use without a GUI to enforce the relationships.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Printing detailed Tasks list (2003)

    Prototype what you'd like to see in Excel or Word and post it as an attachment in this thread, and perhaps someone can knock out a macro which invisibly instances whichever App works better and prints the result; I think Jefferson and unkamunka may have already posted macros instancing Word to provide a custom print solution. If you have very large amounts of body text in the Task , you may run into Excel's cell display limit of about 2000 characters per cell - Word with the Task headers in a table might be better.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Lounger
    Join Date
    Jan 2004
    Location
    Honolulu, Hawaii, USA
    Posts
    47
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing detailed Tasks list (2003)

    Read Chapter 22 of Sue Mosher's book. Seems pretty simple, if all you need is a list of your stuff. a) select the rows you want to print. [img]/forums/images/smilies/cool.gif[/img] Edit, Copy c) go to Excel and Paste.
    The real trick is to right click and Customize Current View... of your Task Folder. A big tip is to put the Notes column first, because they may paste onto several rows in Excel. Two other big tips are to set the sort order and group by in Outlook. Then in Excel, Format, Format Cells..., Alignment, check Word Wrap. Then it's all Excel formatting from there.

  8. #8
    Lounger
    Join Date
    Jan 2004
    Location
    Honolulu, Hawaii, USA
    Posts
    47
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Printing detailed Tasks list (2003)

    Sorry about being vague, hope you understand. My biggest problem is uniquely identifying each task. Then I have a chance for dealing with the hierarchy. Was hoping to find someone familiar with ramifications of adding user-defined field. Am very tempted to wimp out and put it in the beginning of the Subject.
    What I was thinking of doing was dumping the tasks from the spreadsheet into a Public Task Folder. Have someone assign them from there. Have the assignees update their tasks and periodically re-synch the spreadsheet with the Public Folder. Most tasks(Items) have at least a handful of subtasks(Tasks) and they are active for weeks. The overall timeframe is several quarters.

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Printing detailed Tasks list (2003)

    A couple of random comments that may be of use to you and OP Neil:

    1. To print custom forms in WYSIWYG layout, install the tool mentioned in <!post=this thread,457769>this thread<!/post>; that may help with part of the problem

    2. Getting at custom form fields in VBA is a little arcane, you need to use the UserProperties Object and Methods such as:

    objItem.UserProperties.Add(strPropname, varValue)
    objItem.UserProperties.Find(strPropname, <!t>[params]<!/t>)
    objItem.UserProperties.Remove(lngIndex)
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •