An easy way to get a list of messages into a spreadsheet

  • Article

So I mentioned last week that I was using in-cell editing to set properties on items and then I was programatically grabbing them out to form a list of the subject, author, and a few other properties. Well, I just stumbled on a far easier way to get that list of items:

1. Add the desired columns to the view
2. Select the list of items in a folder
3. Ctrl+C to copy
4. Switch to Excel
5. Ctrl+V to paste

And since Excel is so smart, it interprets the tabs as delimeters and everything is put into the expected columns. This even works for the address card view in the contacts folder. Simple, but nice.