+ Reply to Thread
Results 1 to 1 of 1

Excel spreadsheet holiday to Outlook Shared Calendar and update spreadsheet

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    Excel spreadsheet holiday to Outlook Shared Calendar and update spreadsheet

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1