Something I sometimes want to do is extract all of the email addresses for a set of Outlook emails I’ve received and put them in a spreadsheet.
You can do this using Outlook’s Export function, but in Outlook 2010 that function has moved and is harder to find. So my tip of the day is how to export email addresses from emails into Excel in Outlook 2010.
- First, you need to move or copy all the emails you are interested in into their own folder.
- Now go to the Outlook File tab.
- Click “Options” in the left hand menu.
- An Options dialog will pop up. From the left hand menu, Choose “Advanced” .
- Scroll down to the Export section on the right and hit the button marked “Export”.
- In the dialog that pops up, select “Export to a file” and click Next.
- Choose file format “Comma Separated Values (Windows)” and click Next.
- Select the folder all your emails are in and click Next.
- Pick a location and name for the new spreadsheet you want to create and click Next.
- Click the “Map custom fields” button.
- Decide which fields you want to export or just leave it as the default (everything).
- Click finish and your file of email addresses will be created.
- The file format will be CSV (“xxx.csv”) which is readable by Excel and can be saved as an Excel spreadsheet inside Excel.
Fiddly, but fine once you get used to it and far better than copy/paste-ing out email addresses by hand!
At Qlockwork we are Outlook developers with a keen interest is making your PC time more productive. If you want to find out how much time you currently spend in Outlook, or any other application, then try the Qlockwork free trial from our downloads page. Qlockwork automatically works out exactly how you spend your time on your PC.
Outlook 2010 tips from Qlockwork – time tracking for Outlook