HELP!! VBA for Outlook Meeting or Appointments

Hi VBA Gurus,

I am developing a Excel Macro to batch create meeting invites.

It's working well however I want to not include myself when I generate these meeting invites.

I looked online and it's complicated to find any solutions.

So I'm thinking is it possible to clear RequiredAtteendee's list and then rebuild it so it includes other people.

There is a ".RequiredAttendees" property

How do I clear it? .RequiredAttendees.Add doesn't seem to work for me as well.

All I can do is put .RequiredAttendees = "[email protected]"

However I don't know how to remove myself from the meeting. Any ideas would be very appreciative. Thanks for your time!!!

If you are sending the meeting notice from Outlook, you are the organizer. You cannot be an organizer and yet not be included in the meeting, unless you are sending it "On Behalf Of" another user (I'm not 100% sure how that works, but that is for situations like if a person has an assistant, and the assistant has Outlook permissions to schedule meetings for the boss--but the boss is now the organizer and is included). It's just how Outlook works.