Are you planning a big meeting with lots of moving pieces: Catering, handout materials, AV. Wouldn’t it be great to not have to recreate the meeting attendance data from Outlook to do that? Well here’s how you can.
In a meeting where you were the meeting organizer, in the Show group on the Meeting tab, click the lower part of the Tracking button. You’ll find Copy Status to Clipboard. Click this and then paste it into either a Word document, a composed email or an Excel spreadsheet. It might a look a little messy right now, but here’s the neat part of the trick.
Select the text and look in the Insert tab in the Tables group and click the Table button. Near the bottom, you’ll see Convert Text to Table. Select this option and make sure at the bottom that Tab is selected in Separate Text at: Voila! Here’s your meeting attendance data all organized. Use the Word sort feature to sort those attending from those who have declined. You’ll see it in Table Tools contextual tab labeled Layout.
If you paste the data into Excel, it should paste already separated into columns and rows. Now you can use Excel’s sort and filter features to manage the data.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips.
If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/32506/neat-trick-with-meeting-tracking "