Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've got to send a bulk email out to a bunch of people in reply to emails they sent me. I've got all the original emails stored in a single outlook folder. I want to extract all of the reply addresses from the emails in that folder so I can send an email to all of them.

http://thetechieguy.wordpress.com/2008/04/22/extracting-email-address-from-outlook-2007-folder/

shows you how to export the FROM address of these emails, however a large amount of them came from a web service that sends emails 'on behalf of' the person I'm trying to mail to. So I need the reply-to address, and the export wizard doesn't do that.

Does anyone have a tip on how to do this? This is Outlook 2007 on Exchange 2010.

share|improve this question

2 Answers 2

up vote 1 down vote accepted

In the end, I found what I needed using the free CodeTwo Outlook Export utility

It's fairly straight forward, but I've written full instructions on my blog.

share|improve this answer

From Extracting Email Address from Outlook 2007 folder :

So you have a folder that you keep all your sales inquiries. Now from out of nowhere you are instructed to send each person an email with your company’s new catalogue.

Here is what you do:

  • In Outlook 2007, click on File, Import and Export and the Wizard opens up.
  • Select the option to Export to a File and click on Next
  • Select Microsoft Excel 97-2003 (or a CSV file) and click on Next
  • Select the folder that your sales inquiries reside in and click on Next
  • Click on Browse to select a location and then type the file name that you want to export the information to and then click on Next
  • Here is the important bit – click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder. Since we are only interested in Email address, click on Clear Map and then from the Left side click on From: (address) and drag that to the Right list
  • Click on OK
  • Click on Finish

Now watch the magic happen – all the Email address will be exported neatly into an Excel spreadsheet that you can now manipulate and use as you wish !

If you do not have Excel, the CSV option will generate a text file that you can use.

share|improve this answer
    
I linked to that exact post in my question and said that it is not of any use as I need the reply-to address and that option does not come up in the map custom fields menu. Have you had some success getting it to show up in that menu? If so, how? –  RodH257 Feb 3 '11 at 12:40
    
I didn't see this was the same article (will fix this later). Why do you need "reply-to" and not "From: (Address)" ? And there is also the old trick of select-all in the folder, copy, then paste all headers into Excel. –  harrymc Feb 3 '11 at 13:19
    
because a large amount of them came from a web service that sends emails 'on behalf of' the person I'm trying to mail to. Ie the email is from 'do-not-reply@website.com on behalf of person-i-want-to-email@email.com' I tried copying and pasting to excel but it doesn't bring across any email addresses - is there extra options other than just purely selecting all emails, copying and then pasting? –  RodH257 Feb 6 '11 at 23:26
    
I don't understand: You added your own accepted solution. Is it not working? –  harrymc Feb 7 '11 at 8:50

Your Answer

 
discard

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.