Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2015
    Posts
    10
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Help Creating an Outlook Task through VBA

    Hello,

    I would like to do the following in MS Office 2013 and by no means am I well versed in Excel or Outlook. My aim is to establish a means to create an outlook task subject to the character which corresponds on our shift rota.


    At work we have various responsibilities depending on the shift we're on, and by having an outlook task schedule a reminder, it makes it easier to keep on top of things.

    E=Early
    D=Day
    L=Late
    O=Overnight
    H=Holiday
    S=Sick

    Attached is our shift rota, and depending on which rotation we're on, i'm looking to have Excel create an outlook task detailing the below information

    Whom ever is on E (Early Shift) to have an outlook task prompt 'Morning Deployments' at 07:00
    Whom ever is on D (Day Shift) to have an outlook task prompt 'Lunch Time Deployments' at 11:45
    Whom ever is on L (Late Shift) to have an outlook task prompt 'End of Day Checks' at 16:45

    If possible it would be preferred to have daily reminders

    Any help concerning this matter would be highly appreciated.
    Shift Rota.xlsx

    Thank you all in advance.



  2. #2
    New Lounger
    Join Date
    Oct 2015
    Posts
    2
    Thanks
    0
    Thanked 1 Time in 1 Post
    How do you envision this running? At the beginning of the month? Each person has their own shift spreadsheet and they would run a macro to populate their tasks for the month? Something else?

    Bill

  3. #3
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Quote Originally Posted by BGL View Post
    Hello,

    I would like to do the following in MS Office 2013 and by no means am I well versed in Excel or Outlook. My aim is to establish a means to create an outlook task subject to the character which corresponds on our shift rota.


    At work we have various responsibilities depending on the shift we're on, and by having an outlook task schedule a reminder, it makes it easier to keep on top of things.

    E=Early
    D=Day
    L=Late
    O=Overnight
    H=Holiday
    S=Sick

    Attached is our shift rota, and depending on which rotation we're on, i'm looking to have Excel create an outlook task detailing the below information

    Whom ever is on E (Early Shift) to have an outlook task prompt 'Morning Deployments' at 07:00
    Whom ever is on D (Day Shift) to have an outlook task prompt 'Lunch Time Deployments' at 11:45
    Whom ever is on L (Late Shift) to have an outlook task prompt 'End of Day Checks' at 16:45

    If possible it would be preferred to have daily reminders

    Any help concerning this matter would be highly appreciated.
    Shift Rota.xlsx

    Thank you all in advance.



    Yes, it is possible to have reminders set.

    We rally need more information about how this needs to work and your environamnet.

    Do you use Exchange Server?

    If using Exchange sever you could use code to add the tasks and/or reminders to each persons calendar. This way the user doe not have to do anything.


    If you want to use VBA code to add the task, which Office application will the user open to run the VBA code to add add them?

    Is is possible to have Outlook VBA code read an email and add the task as with reminders.

    I like to send tasks and tasks with a reminder to users as an iCal attachment. This can also be sent to smartphones which will add the tasks/reminders to the phone's calendar.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Tags for this Thread

Posting Permissions

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