in message
By used, I am assuming you mean sent to.
On the one hand, you could look for some utility that will allow you
to dump out the contents of your nk2 file, but, on the other hand,
simply setting your sent items to be a table view and copying the
list into Excel might be easier. Tho that would only get you the
To: field and it might need some data massaging...
In the Sent Items folder, sort on the "To" column to see to whom you
have sent e-mails and have those recipients grouped together. Of
course, the sorting is on the first recipient so you still have a
problem if you often send to multiple recipients.
Or, if want you want (but didn't say because you didn't mention how
you are going to use that list), you can try extracting all the To:,
Cc:, and Bcc: fields from all your sent e-mails.
- In Outlook, go into your Sent Items folder.
- Hit Ctrl-A to select all your sent e-mails.
- Use the File -> Save As menu to save all those e-mails into one
file. Make sure .txt is selected as the filetype for the destination
file. For example, save them all into C:\Temp\allsent.txt.
- In a DOS shell, run the following command:
cd C:\Temp
find /i "to: " allsent.txt > mylist.txt
find /i "cc: " allsent.txt >> mylist.txt
find /i "bcc: " allsent.txt >> mylist.txt
- Get rid of any lines that don't have the "@" character required in
an e-mail address:
find "@" mylist.txt > addies.txt
- Get rid of some header lines that have "to:" but are not the "To:"
header:
find /i /v "-to: " addies.txt > mylist.txt
find /i /v " to: " mylist.txt > addies.txt
- The 'find' command shows the file that was searched. Remove those
lines:
find /v "----------" addies.txt > people.txt
- Some cleanup of temp files:
del addies.txt mylist.txt allsent.txt
- You now have the people.txt file as a solid starting point. Use
Notepad on it to get rid some remaining garbage lines:
notepad.exe people.txt
