• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

good tool for exporting sent email "To" field?

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Exchange 2000 // 2003 // 2007 & Active Directory

View previous topic :: View next topic  
Author Message
moondoggie
Lurker
Lurker


Joined: 27 May 2005
Posts: 19


Offline

PostPosted: Mon Jul 11, 2011 8:35 pm    Post subject: good tool for exporting sent email "To" field? Reply with quote

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? Wink
Back to top
View user's profile Send private message
AdamV
SF Mod
SF Mod


Joined: 06 Oct 2004
Posts: 24
Location: Leeds, UK

Offline

PostPosted: Mon Jul 11, 2011 11:57 pm    Post subject: Reply with quote

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.

Hope this helps
Back to top
View user's profile Send private message Visit poster's website
moondoggie
Lurker
Lurker


Joined: 27 May 2005
Posts: 19


Offline

PostPosted: Tue Jul 12, 2011 4:08 am    Post subject: Reply with quote

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;address@somebody.com;person@business.org;email@example.com 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.
Back to top
View user's profile Send private message
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Exchange 2000 // 2003 // 2007 & Active Directory All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
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

Community Area

Log in | Register