Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Programmatically create reminders/tasks (A2k)

    I deal with many classes graduating on forecast dates. I would like to input a task or reminder saying Class XXXX-01 Graduate, set the date, and then have outlook auto-populate tasks backwards from that point (i.e. 7 days before graduation, create certificates; 14 days before graduation, verify personal information; etc...)

    How can I do this?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

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

    Re: Programmatically create reminders/tasks (A2k)

    With a lot of VBA code, or a custom Task Form, or both. <img src=/S/yep.gif border=0 alt=yep width=15 height=15> (I'm not being sarcastic. Outlook Tasks are not very powerful, probably because MS didn't want to step on the toes of its Project application.)

    If you want to use Tasks, search for 'TaskItem" in this Forum and the Lounge VBA Forum. It could also be worth your time to search http://www.Outlookcode.com.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programmatically create reminders/tasks (A2k)

    John,
    Thanks for your advice, but I'm completely at a loss. I have NO clue whatsoever as to where to begin. Outlook forms aren't like Access forms (which are the only ones I have experience with), so I don't even know where to start. I was able to get to the "design" view for a custom task form, however once there it was Greek to me (and I don't speak Greek <img src=/S/groan.gif border=0 alt=groan width=16 height=15>). If anyone can give me some more basic advice on this advanced request, I'd appreciate it. Thanks!
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

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

    Re: Programmatically create reminders/tasks (A2k)

    I don't do Outlook Forms myself. Let me attempt something in VBA which you can work on. Do you work at all in VBA?

    Oops, I see from your Access posts that you work in VBA. Welcome to the Outlook object model - any way you look at it, it sucks, partly because it's a collage of interface and MAPI engine, and (I guess) partly because MS doesn't expose it all because they are trying to prevent it being used as a spam or virus dissemination engine.
    -John ... I float in liquid gardens
    UTC -7ąDS

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

    Re: Programmatically create reminders/tasks (A2k)

    Assuming you are comfortable with the MS VBE interface, the attached zip file contains a very basic form with the code embedded in it. Import the form into the Outlook VBE, then add a caller to a standard module:

    Sub CreateGradClasstasks()
    frmClass_Task_Creator.Show
    End Sub

    Since you have some familiarity with VBA, I don't think you'll have problems adding additional tasks and information to the basics provided. You can probably improve the code a lot, and there isn't any error handling except date validity checks.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programmatically create reminders/tasks (A2k)

    John,
    You made me chuckle with your statement "any way you look at it, it sucks"; I'll check out what you've provided me tonight, and post back soon. Thanks so much for your help.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  7. #7
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Programmatically create reminders/tasks (A2k)

    John,
    What you've given me is exactly what I needed. I've been able to figure a little more out, thanks a lot!
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

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

    Re: Programmatically create reminders/tasks (A2k)

    PS., I couldn't help but monkey with it for my own self-education. One thing, FWIW (first line unchanged):

    dateDue = DateAdd("d", -CInt(Split(strDaysPrior, ";", -1, vbTextCompare)(intC)), txtGradDate)
    If Weekday(dateDue) = 1 Then dateDue = dateDue - 2 ' move Sun to preceding Fri
    If Weekday(dateDue) = 7 Then dateDue = dateDue - 1 ' move Sat to preceding Fri

    It would be nice to use the Calendar Control for date selection, but that's out of my depth. If you build the original into something more powerful and not too narrow in use, please post it back to this thread for other Loungers.
    -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
  •