Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Trying to be clever with Outlook 2007 - help!

Thread Tools
 
Search this Thread
 
Old 12 December 2007, 09:59 PM
  #1  
ScoobyJawa
Scooby Regular
Thread Starter
 
ScoobyJawa's Avatar
 
Join Date: Aug 2001
Location: Hampshire
Posts: 10,954
Likes: 0
Received 0 Likes on 0 Posts
Default Trying to be clever with Outlook 2007 - help!

Hey all

I've got a load of emails in a folder from postmaster or mail delivery system etc to do with a mailing list. These are all the mails that come back as peoples addresses no longer exist.

Is there any clever way of going through them and pulling out the email addresses from the mails into a spreadsheet so I can then process them to remove from the contacts list? Don't want to have to do it manually if I can help it!

Any help mucho appreciated!!
Cheers
Neil
Old 12 December 2007, 10:21 PM
  #2  
HankScorpio
Scooby Regular
 
HankScorpio's Avatar
 
Join Date: Feb 2004
Posts: 5,848
Likes: 0
Received 0 Likes on 0 Posts
Default

Just tried on my undeliverable folder (people spoof my domains)

Export bodies to a text file, run find:
find /i "@" file.txt >file2.txt
to find lines with @
and pull that in to excel...?

not elegant and may well have spurious entries as the formats are all different but a bit of trimming and tidying and it's not *too* bad.
Old 13 December 2007, 10:38 AM
  #3  
ScoobyJawa
Scooby Regular
Thread Starter
 
ScoobyJawa's Avatar
 
Join Date: Aug 2001
Location: Hampshire
Posts: 10,954
Likes: 0
Received 0 Likes on 0 Posts
Default

Thanks mate - I'll have a little play
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Scott@ScoobySpares
Full Cars Breaking For Spares
55
05 August 2018 07:02 AM
MightyArsenal
Wheels, Tyres & Brakes
6
25 September 2015 08:31 PM
Fraser87
Interior
1
22 September 2015 12:38 PM
soupy6667
Lighting and Other Electrical
0
21 September 2015 06:19 AM
Rustless
General Technical
2
14 September 2015 09:34 PM



Quick Reply: Trying to be clever with Outlook 2007 - help!



All times are GMT +1. The time now is 01:03 AM.