Extract reply addresses from all emails in an outlook folder (sent on behalf of)
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.
The article 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.
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.
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.