Print or export a tracking list in Outlook Calendar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Catharina - 18 Apr 2005 09:13 GMT

I frequently invite a large number of people to all-day-meetings or
conferences and use the calendar to follow up the number of people that have
accepted etc. How do I print the trackning view to be able to bring it with
me?

It would be convinient to be able to export the tracking list to Excel in
order to add uniqe arrival time or number of participants at different meals
etc. How can I do this?

Reply to this Message

Milly Staples [MVP - Outlook] - 19 Apr 2005 04:25 GMT

Currently, this is not possible. It may be possible in a future version of
Outlook.

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, Catharina asked:

| I frequently invite a large number of people to all-day-meetings or
| conferences and use the calendar to follow up the number of people
[quoted text clipped - 4 lines]
| Excel in order to add uniqe arrival time or number of participants at
| different meals etc. How can I do this?

Reply to this Message

Hélène - 06 May 2005 16:46 GMT

Catharina,

For lack of a better solution, I tried this and it helps:

On the Tracking tab, I select the attendees (if you want only those who are
attending, select them by using the Ctrl key). Holding down the Ctrl key,
press C to copy.
Launch Excel, get a new spreadsheet.
Paste your selection. Because it sits in one cell, select it, select Data,
Text to Columns, Delimited, Next, Semicolon, Finish.
Your data will be in separate cells. Select the whole row and Copy.
Position your pointer in Cell A2. On the Paste button, click the arrow and
select Transpose.

Tedious but worth it!

> I frequently invite a large number of people to all-day-meetings or
> conferences and use the calendar to follow up the number of people that have
[quoted text clipped - 4 lines]
> order to add uniqe arrival time or number of participants at different meals
> etc. How can I do this?

Reply to this Message