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.

RodH257

Posted 2011-02-03T06:56:59.413

Reputation: 151

Answers

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.

RodH257

Posted 2011-02-03T06:56:59.413

Reputation: 151

There is also a free Save Addresses from Messages to Contact Folder tool that does exactly what you want.

– thims – 2014-08-15T10:28:15.763

This doesn't work for Outlook 2016, the "Send on behalf of" line just exports the same as the "from" line (at least for my web form). It needs to extract the "Reply-to" line from the header. – Mike – 2016-09-20T20:44:54.293

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.

harrymc

Posted 2011-02-03T06:56:59.413

Reputation: 306 093

1I 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 – 2011-02-03T12:40:24.407

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 – 2011-02-03T13:19:32.690

1because 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 – 2011-02-06T23:26:06.093

I don't understand: You added your own accepted solution. Is it not working? – harrymc – 2011-02-07T08:50:47.847