Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .