+ Reply to Thread
Results 1 to 1 of 1

Outlook Calendar Entries

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver

    Question Outlook Calendar Entries

    First ever post!

    I am looking to try and add the function of adding your allocated time slots to your outlook calendar.

    Attached is the roster I have created, which allows you to choose your name from the drop down box at the top and then it will highlight where you have been allocated to work on the helpdesk.

    What I am looking to create is a button that once you have selected your name, it then creates calendar entries based on where you have been allocated.

    The subject of the appointment would be the helpdesk name, the date would be the header (formatted as dddd presently) and the time is listed to the left of the employee name.

    A copy of the template sheet is created every week and the old one hidden, so anything I need to add needs to be hidden amongst the template.

    Is this possible at all? I wasn't sure how to make the VBA work to only create entries that contains particular text
    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)

Similar Threads

  1. [SOLVED] Calendar appointments in Outlook via VBA
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-15-2013, 08:11 AM
  2. VBA Import from Outlook Calendar
    By davidcollins01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2008, 06:42 AM
  3. To export to outlook calendar
    By zort in forum Excel General
    Replies: 0
    Last Post: 04-21-2006, 02:50 PM
  4. [SOLVED] import calendar items from excel into outlook calendar
    By jsewaiseh in forum Excel General
    Replies: 0
    Last Post: 09-02-2005, 11:05 AM
  5. Outlook Calendar in Excel
    By koltregaskes in forum Excel General
    Replies: 0
    Last Post: 02-08-2005, 11:34 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1