OK - so I have a folder full of messages I'd like to reply to. I want to extract the From e-mail addresses, paste them into a spreadsheet and then mail merge these people a new, personalized message. When I just blindly copy the messages and try to drop them into Excel, some contacts are just names and some are e-mail addresses. Is there a way to force Outlook to only display their addresses? If not, is there a better way to get this information out of the folder?
You could try exporting the message, with the Import/Export Wizard, into a more usable/generic format like .CSV (Comma Separated Values).
You get to the Export Wizard in Outlook 2010, go to
I haven't used it, but there's also a beta add-on for Outlook 2010 that is specifically aimed at exporting stuff, with many options. You can check that out on codeplex.com: Outlook Data Export 2.0