In an earlier post, we showed you how to export outlook contacts to a CSV file.
We had several readers asking if there was a way to extract email addresses from emails directly to external files like CSV…
The answer is YES and you don’t need any new program, you can use Outlook’s in-built Export feature to do this.
- The first thing you need to do is move/copy all the emails you wish to extract into a separate folder. For example you can create a folder called “Export”.
- In Outlook 2010, click File > Options > click on Advanced from the left pane > Scroll down and click on the Export button
For Outlook 2007/2003, On the main menu Click File > Import and Export…
- Click Export to a file > click Next >
- Select Comma Separated Values (Windows) > click Next >
- On the next screen, select the folder which contains the emails from which you wish to extract the email addresses
* Click the Browse… button to specify a location and file name for the new file.
* Click Next >
* Click Finish.
This should now extract the email address (and other information) from the emails to the new CSV file.
Wondering how this tip is handy?
If you do not want to invest in expensive, subscription-based, online email marketing systems, you can use Outlook and Email Merge for the same.
You can use the steps provided in this post to extract email addresses of your potential clients following a conference, seminar or any other event (who have contacted you) to a CSV file. You could also add them to your Contacts folder but this will be time-consuming as you will have to create each contact individually.
Once all email addresses are in the CSV file, you can use Email Merge for Outlook to create and send personalized emails to your mailing list. With Email Merge, you can send out unlimited number of emails, there is no monthly or yearly fee’s and you can load unlimited contacts from Outlook contacts and external files like CSV, Excel or even Access.
Hope you find this tip useful.
Do you know of other ways the Export feature can be handy?
let us know by leaving a comment below.
7 Replies to “Extract Email Addresses from Emails to CSV”
I am glad for writing to let you know what a excellent discovery my girl obtained studying your blog. She picked up a lot of pieces, most notably what it is like to possess an amazing coaching spirit to make many others completely know specific problematic topics. You truly did more than our expected results. I appreciate you for churning out those powerful, safe, revealing and cool tips about your topic to Kate.
Thank you for posting this. Simple to follow, extremely helpful!
Thanks for Your valuable post.Simple and helpful
Thanks for sharing and helping me save some money.
thanks! clear, simple, to the point.
cant make this work from a list server. the email address is in the from: header…just separated by a character that truncates the header? upon extraction? or its just giving me the text name and not the link e.g John Doe ie lieu of firstname.lastname@example.org
Could you send this issue to email@example.com