VBA and/or any language that supports regular expressions.
Seems like 1000 mails with rather unstructured data isn't the optimal way to collect data. Why didn't your business make some database application with a web front end for the contact to fill in? Or even a html mailto-form, which gives structured output, which is much easier to process in the application you have to write.
I'm afraid the fastest way to do this is to hire someone who's good in using copy/paste.
Hope this helps.
I got near a 1,000 business emails with email addresses and contatc details in them- i would like to extract the information from them and send it to an excel file. How would i do this?- is there any software that does this? Is there a macro of some sort or "robot" that can scan through it all and do this - I have all the individual emails in outlook - I wana tell the program to find data that has @ in in an export and also numbers beginnign with 07 to export.
sum1 help please? :s