Tim H said:
I've somehow lost my Contact folder. In an effort to recover I'm looking
for
a way to easily extract all email addresses from my Sent folder. Is there
an
app, maybe even freely available, out there that does this sort of stuff.
Any text readable format would be fine.
If there is an app, it'd probably be at
http://www.slipstick.com/addins/contacts.htm, but, if you're comfortable
playing in Excel, here's what I would do:
1) Build a view that only shows you the To and CC fields in Table view.
2) Go into the Sent Items, apply the view, turn off the preview pane,
select all the items and do Control-C
3) Fire up Excel and paste it in.
4) Do some editing in excel using formulas to break up the email address
from any display names (I'd probably use Excel to remove duplicate entries
first).
5) Create a contact in Outlook and export it so you're familiar with what
the column headings should look like
6) Import the spreadsheet that you've worked on in #4 into Contacts.
The steps are a bit vague because, while it's pretty easy to do (if you're
comfortable with data manipulation in Excel), it's quite a few intricate
steps. Conversely, if you're comfortable with a little coding, you could
probably do it in VBA more easily. You might want to check the forums at
http://www.outlookcode.com (heck, there might already have been a discussion
on how to do it there).
I'd only do it in Excel personally because while I can code, I think I could
get it done faster in Excel than I could in VBA.
