Expand group in meeting request using VBA

melon · Joined: 21 Feb 2008 Posts: 4

Say I have a meeting request to a distribution group. In order to see
the meeting response I will have to manually expand the group. How
could I do it using VBA?

Archived from group: microsoft>public>outlook>program_vba

melon · Joined: 21 Feb 2008 Posts: 4

On Feb 22, 11:44 am, melon wrote:
> Say I have a meeting request to a distribution group. In order to see
> the meeting response I will have to manually expand the group. How
> could I do it using VBA?

To be specific, I have a DL as Recipient. I want to resolve the
meeting response status for each of the member inside the DL.

Eric Legault [MVP - Outlo · Joined: 12 Aug 2007 Posts: 5

Loop through the MeetingRequest.Recipients collection to find your DL and
get a Recipient object for it; then you can access the DL's members using
the Recipient.AddressEntry.Members collection.

--
Eric Legault - MVP - Outlook
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3
Application Development, MOSS 2007 Application Development)
Blog: http://blogs.officezealot.com/legault
Try Picture Attachments Wizard for Outlook!
http://www.collaborativeinnovations.ca

"melon" wrote in message @d5g2000hsc.googlegroups.com...
> On Feb 22, 11:44 am, melon wrote:
>> Say I have a meeting request to a distribution group. In order to see
>> the meeting response I will have to manually expand the group. How
>> could I do it using VBA?
>
> To be specific, I have a DL as Recipient. I want to resolve the
> meeting response status for each of the member inside the DL.

melon · Joined: 21 Feb 2008 Posts: 4

On Feb 25, 12:03 pm, "Eric Legault [MVP - Outlook]"
wrote:
> Loop through the MeetingRequest.Recipients collection to find your DL and
> get a Recipient object for it; then you can access the DL's members using
> the Recipient.AddressEntry.Members collection.
>
> --
> Eric Legault - MVP - Outlook
> MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3
> Application Development, MOSS 2007 Application Development)
> Blog:http://blogs.officezealot.com/legault
> Try Picture Attachments Wizard for Outlook!http://www.collaborativeinnovations.ca
>
> "melon" wrote in message
>
> @d5g2000hsc.googlegroups.com...
>
> > On Feb 22, 11:44 am, melon wrote:
> >> Say I have a meeting request to a distribution group. In order to see
> >> the meeting response I will have to manually expand the group. How
> >> could I do it using VBA?
>
> > To be specific, I have a DL as Recipient. I want to resolve the
> > meeting response status for each of the member inside the DL.

So I retrieve the member of the DL in AddressEntry.Member. Isn't this
just a AddressEntries collection that does not have meeting response
stored anywhere? How do I retrieve the meeting response then?

Eric Legault [MVP - Outlo · Joined: 12 Aug 2007 Posts: 5

The Recipient.MeetingResponse status property will tell you. Since you
obtained the Recipients collection from the MeetingRequest item, it tags
specific info for each recipient in that meeting. A Recipients collection
can be obtained from many items, but MeetingResponse is only relevant to
MeetingRequest items.

Eric

"melon" wrote in message @k2g2000hse.googlegroups.com...
> On Feb 25, 12:03 pm, "Eric Legault [MVP - Outlook]"
> wrote:
>> Loop through the MeetingRequest.Recipients collection to find your DL and
>> get a Recipient object for it; then you can access the DL's members using
>> the Recipient.AddressEntry.Members collection.
>>
>> --
>> Eric Legault - MVP - Outlook
>> MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, WSS 3
>> Application Development, MOSS 2007 Application Development)
>> Blog:http://blogs.officezealot.com/legault
>> Try Picture Attachments Wizard for
>> Outlook!http://www.collaborativeinnovations.ca
>>
>> "melon" wrote in message
>>
>> @d5g2000hsc.googlegroups.com...
>>
>> > On Feb 22, 11:44 am, melon wrote:
>> >> Say I have a meeting request to a distribution group. In order to see
>> >> the meeting response I will have to manually expand the group. How
>> >> could I do it using VBA?
>>
>> > To be specific, I have a DL as Recipient. I want to resolve the
>> > meeting response status for each of the member inside the DL.
>
> So I retrieve the member of the DL in AddressEntry.Member. Isn't this
> just a AddressEntries collection that does not have meeting response
> stored anywhere? How do I retrieve the meeting response then?

How to send calendar appointment or meeting request using .N How to send outlook calendar appointment or meeting request using .Net classes or assemblies?

Sending a Meeting Invitation Update I have developed an MS Access application for tracking reservations in training classes. I am now adding the Outlook objects to trigger the system to send an meeting invitation any time someone is registered in a class. However, I'm running into a problem

New Meeting Request When I make new a meeting request it attaches to my calendar and I can see the tracking tab. Is there anyway to transfer/copy the request to another person's calendar with whom I have sharing rights, so that they can see the attendance on the tracking ta

Meeting Request Replies My assistant has all permission to my calendar. How can the calendar be configured in that all replies from events sent from my calendar (via by assistant) goes into her inbox or she get the replies? This is only for calendar events, not other emails. T

Custom Meeting Request form I want to customise the Meeting Request form. I have added a new Meeting Request Form from Design Form section. In one of the tabs (P.2) I have placed some controls (textbox, and "Required Attendees" field from Field Chooser options. How c