Results 1 to 3 of 3
2015-10-12, 03:26 #1
- Join Date
- Sep 2015
- Thanked 0 Times in 0 Posts
Help Creating an Outlook Task through VBA
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.
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.
Thank you all in advance.
2015-10-19, 18:30 #2
- Join Date
- Oct 2015
- 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?
2015-10-19, 20:23 #3
- Join Date
- Sep 2011
- Oklahoma City, OK
- Thanked 31 Times in 30 Posts
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."