Posted: Mon Jul 11, 2011 8:35 pm Post subject: good tool for exporting sent email "To" field?
i am trying to export the "To" field for a client from their sent emails over a period of one year. we have Exchange 2007 and i have successfully exported the sent messages during that time frame into a PST but when i try to export that PST into Excel, i not only get hundreds of duplicates (expected) but i also get multiple "To" addresses on the same line. does anyone have a tool they can recommend (preferably free) that can separate these fields so i don't have to do quite so much work?
Assuming the email addresses are separated by something (a space, semicolon, comma, etc), you could simply use the "text to columns" feature in Excel.
This will split it out into separate columns, and you should then be able to easily copy and paste everything from column B below A, then C below those etc, then use duplicate removal to take the dupes out.
Thinking about it, you should run dupe removal once before you do all that to reduce the number of rows you have to play with. Obviously some addresses will turn up more than once on emails in different combinations, but there are likely to be many sent to only one person or to a consistent group.
So de-dupe, then split columns, copy and paste, de-dupe final result. If you have problems with too many rows to paste everything in one column, do a de-dupe after every paste to keep the size down.
the problem i was having was that when i did "export to file -> Excel 97-2003" i would get an Excel file which had a single line reading something like "/OU=xx,/CN=xx/OTHER EXCHANGE DATA;firstname.lastname@example.org;email@example.com;firstname.lastname@example.org etc all on one single line. i ended up finding a program from DSDevelopment installed on one of our users' computers which took all those PSTs and allowed me to export every address it found into a single column in an excel file.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Looking for more Windows Networking info?
Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing! View a sample newsletter.
Become a WindowsNetworking.com member!
Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!