Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / February 2008

Tip: Looking for answers? Try searching our database.

Expand group in meeting request using VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
melon - 22 Feb 2008 16:44 GMT
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?
melon - 22 Feb 2008 16:55 GMT
> 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 - Outlook] - 25 Feb 2008 17:03 GMT
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.

Signature

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

>> 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 - 25 Feb 2008 18:46 GMT
On Feb 25, 12:03 pm, "Eric Legault [MVP - Outlook]"
<elegault...@REMOVEZZZmvps.org> 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
[quoted text clipped - 13 lines]
> > 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 - Outlook] - 27 Feb 2008 21:37 GMT
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

> On Feb 25, 12:03 pm, "Eric Legault [MVP - Outlook]"
> <elegault...@REMOVEZZZmvps.org> wrote:
[quoted text clipped - 20 lines]
> just a AddressEntries collection that does not have meeting response
> stored anywhere?  How do I retrieve the meeting response then?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.