I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of invitees
and threir responses to a meeting request (what is visible when you select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a way to
print or even copy this info. He has more than two pages of invitees, and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to an
Access database, but did not see a field in the calendar table that seemed to
handle meeting attendees.

----
HTH
Dale

Regardless of the fact that you're trying to do this within Access, this is
an Outlook Automation question and thus appropriate for the Outlook
newgroups. Automation is simply code within one application that reaches out
to work with another. Its irrelevant if you're using Access, Word, Excel or
Power Point, its all Outlook.

To that end.

Are you storing information in the Access database on the meeting? Where
does Access come into play with the Meeting Request? Are you creating the
Meeting Request in Access to begin with?

Yes it is entirely possible, but you're trying to do this from within Access
you have to locate the MeetingItem first. How you do that depends on how the
Meeting Request is being created to begin with as there are ways to do this
that are easier than others.


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of invitees
and threir responses to a meeting request (what is visible when you select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a way
to
print or even copy this info. He has more than two pages of invitees, and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to an
Access database, but did not see a field in the calendar table that seemed
to
handle meeting attendees.

----
HTH
Dale

It's stored in the Appointment.Recipients collection; see
http://www.outlookcode.com/codedetail.aspx?id=1130 and
http://www.outlookcode.com/codedetail.aspx?id=1418 for Outlook VBA code
samples.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of invitees
and threir responses to a meeting request (what is visible when you select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a way
to
print or even copy this info. He has more than two pages of invitees, and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to an
Access database, but did not see a field in the calendar table that seemed
to
handle meeting attendees.

Actually, Dave, I would prefer to do it in Outlook. But when I couldn't
figure out how to get a simple printout of the meeting request recipients and
their response, I went to Access (my area of expertise) to see whether I
could find a field in either the calendar or mail item collection that had
that information, but did not find one. Thats when I posted my note.

----
HTH
Dale



"David C. Holley" wrote:

Regardless of the fact that you're trying to do this within Access, this is
an Outlook Automation question and thus appropriate for the Outlook
newgroups. Automation is simply code within one application that reaches out
to work with another. Its irrelevant if you're using Access, Word, Excel or
Power Point, its all Outlook.

To that end.

Are you storing information in the Access database on the meeting? Where
does Access come into play with the Meeting Request? Are you creating the
Meeting Request in Access to begin with?

Yes it is entirely possible, but you're trying to do this from within Access
you have to locate the MeetingItem first. How you do that depends on how the
Meeting Request is being created to begin with as there are ways to do this
that are easier than others.


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of invitees
and threir responses to a meeting request (what is visible when you select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a way
to
print or even copy this info. He has more than two pages of invitees, and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to an
Access database, but did not see a field in the calendar table that seemed
to
handle meeting attendees.

----
HTH
Dale



.

Sue,

How do I make the VBA window visible in Outlook?

----
HTH
Dale



"Sue Mosher [MVP]" wrote:

It's stored in the Appointment.Recipients collection; see
http://www.outlookcode.com/codedetail.aspx?id=1130 and
http://www.outlookcode.com/codedetail.aspx?id=1418 for Outlook VBA code
samples.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of invitees
and threir responses to a meeting request (what is visible when you select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a way
to
print or even copy this info. He has more than two pages of invitees, and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to an
Access database, but did not see a field in the calendar table that seemed
to
handle meeting attendees.


.

Same way as in any other Office application: From the main menu, Alt+F11 or
Tools | Macro | Visual Basic Editor
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Dale Fye" wrote in message
...
Sue,

How do I make the VBA window visible in Outlook?

----
HTH
Dale



"Sue Mosher [MVP]" wrote:

It's stored in the Appointment.Recipients collection; see
http://www.outlookcode.com/codedetail.aspx?id=1130 and
http://www.outlookcode.com/codedetail.aspx?id=1418 for Outlook VBA code
samples.


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of
invitees
and threir responses to a meeting request (what is visible when you
select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a
way
to
print or even copy this info. He has more than two pages of invitees,
and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to
an
Access database, but did not see a field in the calendar table that
seemed
to
handle meeting attendees.

What happens when you open the Meeting Item and click print? I seem to
recall that they meeting attendee status used to appear there.

David (hint)

"Dale Fye" wrote in message
...
Actually, Dave, I would prefer to do it in Outlook. But when I couldn't
figure out how to get a simple printout of the meeting request recipients
and
their response, I went to Access (my area of expertise) to see whether I
could find a field in either the calendar or mail item collection that had
that information, but did not find one. Thats when I posted my note.

----
HTH
Dale



"David C. Holley" wrote:

Regardless of the fact that you're trying to do this within Access, this
is
an Outlook Automation question and thus appropriate for the Outlook
newgroups. Automation is simply code within one application that reaches
out
to work with another. Its irrelevant if you're using Access, Word, Excel
or
Power Point, its all Outlook.

To that end.

Are you storing information in the Access database on the meeting? Where
does Access come into play with the Meeting Request? Are you creating the
Meeting Request in Access to begin with?

Yes it is entirely possible, but you're trying to do this from within
Access
you have to locate the MeetingItem first. How you do that depends on how
the
Meeting Request is being created to begin with as there are ways to do
this
that are easier than others.


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of
invitees
and threir responses to a meeting request (what is visible when you
select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a
way
to
print or even copy this info. He has more than two pages of invitees,
and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to
an
Access database, but did not see a field in the calendar table that
seemed
to
handle meeting attendees.

----
HTH
Dale



.

figured out how to get to the VBA editor but now:

I copied the code into a code module in Outlook 2007, and am getting an
error (287 Application-defined or object defined error) on the line:

Set objAttendees = objItem.Recipients

When I print objItem in the debug window, it gives me the subject of the
meeting.

objSelection.Class = 74

Any ideas?

I've got a meeting request that I created up on screen.

Dale


--
----
HTH
Dale



"Sue Mosher [MVP]" wrote:

It's stored in the Appointment.Recipients collection; see
http://www.outlookcode.com/codedetail.aspx?id=1130 and
http://www.outlookcode.com/codedetail.aspx?id=1418 for Outlook VBA code
samples.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of invitees
and threir responses to a meeting request (what is visible when you select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a way
to
print or even copy this info. He has more than two pages of invitees, and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to an
Access database, but did not see a field in the calendar table that seemed
to
handle meeting attendees.


.

Which code sample are you using? What is the statement that instantiates
objItem? What's the value of objItem.Class?
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Dale Fye" wrote in message
...
figured out how to get to the VBA editor but now:

I copied the code into a code module in Outlook 2007, and am getting an
error (287 Application-defined or object defined error) on the line:

Set objAttendees = objItem.Recipients

When I print objItem in the debug window, it gives me the subject of the
meeting.

I've got a meeting request that I created up on screen.

"Sue Mosher [MVP]" wrote:

It's stored in the Appointment.Recipients collection; see
http://www.outlookcode.com/codedetail.aspx?id=1130 and
http://www.outlookcode.com/codedetail.aspx?id=1418 for Outlook VBA code
samples.

"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of
invitees
and threir responses to a meeting request (what is visible when you
select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a
way
to
print or even copy this info. He has more than two pages of invitees,
and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to
an
Access database, but did not see a field in the calendar table that
seemed
to
handle meeting attendees.


.

It just prints the basic information (addressees, subject, dates/times, body
of the message.

Besides, he needs to get this into some form of Word or PPT document, so
being able to print it does not help!

----
HTH
Dale



"David C. Holley" wrote:

What happens when you open the Meeting Item and click print? I seem to
recall that they meeting attendee status used to appear there.

David (hint)

"Dale Fye" wrote in message
...
Actually, Dave, I would prefer to do it in Outlook. But when I couldn't
figure out how to get a simple printout of the meeting request recipients
and
their response, I went to Access (my area of expertise) to see whether I
could find a field in either the calendar or mail item collection that had
that information, but did not find one. Thats when I posted my note.

----
HTH
Dale



"David C. Holley" wrote:

Regardless of the fact that you're trying to do this within Access, this
is
an Outlook Automation question and thus appropriate for the Outlook
newgroups. Automation is simply code within one application that reaches
out
to work with another. Its irrelevant if you're using Access, Word, Excel
or
Power Point, its all Outlook.

To that end.

Are you storing information in the Access database on the meeting? Where
does Access come into play with the Meeting Request? Are you creating the
Meeting Request in Access to begin with?

Yes it is entirely possible, but you're trying to do this from within
Access
you have to locate the MeetingItem first. How you do that depends on how
the
Meeting Request is being created to begin with as there are ways to do
this
that are easier than others.


"Dale Fye" wrote in message
...
I have cross posted this to the Access-General, Outlook-General, and
Outlook-programming-vba news groups to expand my pool of expertise.

I have a co-worker that wants to be able to print out the list of
invitees
and threir responses to a meeting request (what is visible when you
select
the "Show - Tracking" ribbon option in 2007. We cannot figure out a
way
to
print or even copy this info. He has more than two pages of invitees,
and
would prefer not to do a screen print.

Any ideas?

Is this information visibile from within VBA? I linked my calendar to
an
Access database, but did not see a field in the calendar table that
seemed
to
handle meeting attendees.

----
HTH
Dale



.



.