none
How to un-check a meeting attendee/resource programmatically RRS feed

  • Question

  • I have a macro that creates a meeting request, automatically adding in all my building's conference/meeting rooms so the user can quickly see which rooms are available without manually adding them to the attendee list. It works cleanly with one hiccup: how can I have an attendee un-checked on the Scheduling Assistant tab? We have about 20 conference rooms, and I'd rather the utility simply show the list of rooms and not require the user to un-check all the rooms except the one they want.

    Can that little checkbox to the left of the attendee/resource be un-checked programmatically?

    Here is the code (condensed for brevity):

        Dim objOL 'As Outlook.Application
        Dim objAppt 'As Outlook.AppointmentItem
        Const olAppointmentItem = 1
        Const olMeeting = 1
        Set objOL = CreateObject("Outlook.Application")
        Set objAppt = objOL.CreateItem(olAppointmentItem)
        
        With objAppt
            .Subject = ""
            .Start = Now
            
            .End = DateAdd("h", 1, .Start)
            'make it a meeting request
            .MeetingStatus = olMeeting
            .Resources = "" & _
                "CR 1012;" & _
                "CR 1013;" & _
                ";" & _
                ""
            .Display
            .Recipients.ResolveAll
        End With
        Set objAppt = Nothing
        Set objOL = Nothing

    Thanks,

    david

    Wednesday, May 30, 2012 2:59 PM

All replies

  • Hi David,

    I have the same problem..

    Since your message, have you found a way to make it ?

    Thanks

    Nico

    Tuesday, June 18, 2013 1:03 PM
  • Hi David,

    I do not have found the way to uncheck the little boxes, but I think I have found a way around it :

    I created an appointment with all my ressources, manually unchecked the boxes and then I saved it.

    You can the use  either the ItemID our a precise subject or any particularity you gave it to find this meeting and copy it in a new meeting.

    Then you modify the new meeting ... (dates, subject, other attendees, deleting ressources that you do not want, ...)

    I hope this will help.

    Pierre

    Wednesday, October 15, 2014 5:08 PM
  • see the response to David
    Wednesday, October 15, 2014 5:09 PM
  •  Please check if this works. Add  below code before .display statement

    .Recipients.Item(1).Sendable = False
            .Recipients.Item(2).Sendable = False
            .Display

    Regards,

    Amol

    • Proposed as answer by Amol Gargote Tuesday, October 21, 2014 5:27 AM
    • Unproposed as answer by Amol Gargote Monday, October 27, 2014 6:32 AM
    Thursday, October 16, 2014 9:29 AM
  • Hello Amol,

    The "sendable" property exists in outlook 2010, but not in outlook 2007.
    I did not try yet, but I will see today and tell you if this work in outlook 2007.

    Sincerely

    Pierre

    Friday, October 17, 2014 4:32 AM
  • Hello,

    I made the tests. Sorry but it does not work in Outlook 2007.

    Sincerely

    Pierre

    Thursday, October 23, 2014 3:13 AM