I am writing a Class Registration ap. People sign up for a class on an excel spreadsheet. The Excel VBA code sends an email to the trainer and the trainer's outlook VBA code autmatically sends a meeting request to the registrant to put the class appointment on his/her calendar. If I do this manually, when the second person requests I would add them to the meeting and hit SEND. When I hit SEND manually, outlook has a pop-up message that asks whether I want to send the update to all of the attendees on the list or just the ones that have been added.

I want to send the meeting request only to the new registrtant and not to everyone who has previously registered, else the previoous registrants will keep getting meeing updates each time someone registers. When I execute my code, all of the attendees are sent the message or I get the pop-up window waiting for a response (manual response). I want some way to tell the Send function to only to send to the newly added person and not to prompt the trainer to decide. I have searched high and low for some meeting property that says .MeetingType = olUpdataChanges or something to that effect. There doesn't seem to be anything that does this function. Nor does there seem to be any .Send options. The code is almost useless to me if it is not automatic and prompts the trainer for input each time someone registers.

My alternative is to just send the meeting update it to all registrants each time someone registers, but that means if 20 people sign up the first registrant will get his meeting request and 19 updates, the second 18 etc. They will not be happy with this.


Does anybody know if there is an AppointmentItem setting that controls this or if there is a way to automatically answer the darn pop-up prompt?

thanks
jpgeek