Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 1 down vote accepted

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 File-->Options-->Advanced-->Export to open the Import And Export Wizard (I believe File-->Open-->Import works as well), and chose "Export to a file".

See here and/or here for more info.

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 Outlook Data Export 2.0

share|improve this answer
Perfect - I didn't know you could export the folder to CSV. thanks! – 分かりますか Aug 11 '11 at 15:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.