Monday, February 7, 2011

[General IT]–How to export the ‘on behalf of’ address of all emails in a folder in Outlook

We recently hired a new I.T. assistant at Bornhorst + Ward, and I wanted to email everyone who applied for the job to let the know the position was no longer available. I had all the application emails in one folder, and just needed to extract the email addresses.

If the emails were sent direct to me, that is easy to do, you can do it using the import and export wizard.

Just go to export to a file

image

Choose CSV

image

Select the folder

image

Name the CSV

image

and you are done, open it in excel and you have the addresses.

But, a number of applications came through a web based job advertisement board, which sends the emails from ‘do-not-reply@jobboard.com on behalf of the-real-person@emailserver.com’. Unfortunately this information seems really hard to get to in outlook. You could hit reply on each email one by one, but the import and export wizard, and the field chooser both don’t give you access to this.

Luckily, there is a free export add-in which can do it. CodeTwo Outlook Export is available from their website, download the 32bit or 64bit version based on what version of Office you installed – probably 32bit and install it.

You can then go to the folder and hit the tiny export button

image

Click the ‘add’ button to select a new field and choose ‘Sent on behalf of (address)’

image

Then just follow the wizard, and you’ll have a CSV file with the actual address for you to email.

1 comment:

dee said...

Thank you so much!