tigerdel
New member
- Joined
- Aug 23, 2012
- Messages
- 40
- Reaction score
- 0
- Points
- 0
- Location
- Cambridgeshire
- Excel Version(s)
- Office 365
Hi All
I have an Absence Request Form for Employees to Request Leave and Notify Siccknees that I want to do the following:
In the Absence Tab
I would like it too:
1. Read Name, Start date, end date
2. Check to ensure Request not already in Shared calendar
3. Open Outlook meeting request
4. Enter Name, start date, end date and message and send to manager
5. Enter dates in appropriate sheet for that month as T [Tentative]
I am guessing I need to Send details to Outlook and somehow save the Absence Form so the Manager can then click the Approved by Manager button [to be password protected] and then update the appropriate sheet as below
1. When approved by the manager, convert the T to H [if full day vacation] or HD [if half day vacation] or LTH [if Half Lieu Day taken] or LT [if Full Lieu Day Taken] or S [if sickness]
I have anonymised the entire file so you can play
Any ideas
I have an Absence Request Form for Employees to Request Leave and Notify Siccknees that I want to do the following:
In the Absence Tab
I would like it too:
1. Read Name, Start date, end date
2. Check to ensure Request not already in Shared calendar
3. Open Outlook meeting request
4. Enter Name, start date, end date and message and send to manager
5. Enter dates in appropriate sheet for that month as T [Tentative]
I am guessing I need to Send details to Outlook and somehow save the Absence Form so the Manager can then click the Approved by Manager button [to be password protected] and then update the appropriate sheet as below
1. When approved by the manager, convert the T to H [if full day vacation] or HD [if half day vacation] or LTH [if Half Lieu Day taken] or LT [if Full Lieu Day Taken] or S [if sickness]
I have anonymised the entire file so you can play
Any ideas