+ Reply to Thread
Results 1 to 3 of 3

Adding new appointment after each accepted meeting invite

  1. #1
    Registered User
    Join Date
    08-11-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    41

    Adding new appointment after each accepted meeting invite

    I've got a problem at work where people literally invite me to meetings one after another. They check my calendar and if see a slot put a meeting. This really annoys me as I may be required to attend multiple meetings throughout a day without any break at all. It is also a hassle to go afterwards and ask to reschedule.

    I was wondering if there is a macro or any other way of doing this so when I accept a meeting then a new private appointment is added to my calendar straight away, which would automatically stop colleagues from inviting me to a meeting straight after last one, for example if I get an invite for a meeting from 14:00 to 15:00 and I accept it then straight away new private appointment gets added to my calendar from 15:00 to 15:30.

  2. #2
    Valued Forum Contributor vba_php's Avatar
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    1,626

    Re: Adding new appointment after each accepted meeting invite

    based on everything you said, this doesn't make sense:
    Quote Originally Posted by illusionek View Post
    for example if I get an invite for a meeting from 14:00 to 15:00 and I accept it then straight away new private appointment gets added to my calendar from 15:00 to 15:30.
    that sounds like an attempt by you to pretend that you are busy for EVERY half an hour timeslot in your schedule AFTER you accept an hour long meeting at any given time. is that what you're attempting to do here? fill timeslots in your day via calendar entries after you officially accept a meeting invite so your co-workers will not sending you meeting invites one after the other, as you've stated?

    if that's ur issue, then obviously you can do it. like all office programs, anything you can do through the interface can be done with VBA code using the program's object model. well, almost anything. and I'm pretty sure cal. entries and meetings are part of the object model. to get started with learning, check these out:

    https://docs.microsoft.com/en-us/off...k/object-model

    https://docs.microsoft.com/en-us/off...k-object-model
    -Adam (please don't call me ""sir"" or ""vba_php"")!

  3. #3
    Registered User
    Join Date
    10-06-2020
    Location
    Cologne, Germany
    MS-Off Ver
    Microsoft Office 2020
    Posts
    10

    Re: Adding new appointment after each accepted meeting invite

    Thanks for this info.

+ 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. Extract Outlook meeting request sent status in excel.
    By Parth007 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2019, 03:17 PM
  2. [SOLVED] Incerting the Date in an Outlook meeting invite generated from Excel
    By Frankie_The_Flyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2018, 10:38 PM
  3. [SOLVED] Outlook 2016 - VBA Macro for replying with attachment in meeting invite
    By JaCrispy in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 04-06-2018, 07:45 PM
  4. Outlook meeting invite using cell values
    By JRC1 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 04-05-2017, 07:13 AM
  5. Accepting a meeting invite without responding
    By scott.xlsx in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2015, 05:31 PM
  6. Meeting invite via Excel
    By JimmyQ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2014, 08:20 AM

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