Extracting data from several Word Docs

[BenzComander]

Is there a way of extracting names and addreses from several Word documents. The format of the Word documents is the same, and the data is recorded in a Word table in each doc. We want to create a mailing list.

Any help would be appreciated,

 

[smartbrabus]

Copy and paste into Excel, remove the unwanted data, save as comma separated values or somthing your mailer understands?

Or if you're feeling handy, save the documents as a text files, and write a Perl script to extract the names from each file using a regular expression into an output file.

 

[BenzComander]

Copy and paste into Excel, remove the unwanted data, save as comma separated values or somthing your mailer understands?

Or if you're feeling handy, save the documents as a text files, and write a Perl script to extract the names from each file using a regular expression into an output file.

A what script, excuse my ignorance!! Copy and paste sounds good though!

Is a Perl script pretty straight froward???

Thanks!

 

[smartbrabus]

Perl is a high level programming language, used a lot for text manipulation purposes. Probably best to avoid, since you may be able to acheive what you need within MS Office...

 

[Andyni]

Place the data into excel, save the document and then see the following articles.

http://office.microsoft.com/en-us/help/HA010349201033.aspx

 

[masqueraid]

Depends how many documents you're talking about and whether or not the format is truly identical. If the answer is lots and yes then a macro will do it but I guess from your response to the Perl suggestion is that you don't want a solution that involves programming(!)

A quick and dirty approach would be to open a new blank document and then insert each of the Word files you are talking about into this ("Insert File") which will give you all your information in one big document. Then simply edit out all the irrelevant bits and then see if the tables that are left can be exported into Excel for merging as in the link above.

 

[SimonsMerc]

Read the "Extracting Data from Word Tables Programmatically" section of http://msdn2.microsoft.com/en-us/library/aa537149(office.11).aspx

-simon

 

[Howard]

Read the "Extracting Data from Word Tables Programmatically" section of http://msdn2.microsoft.com/en-us/library/aa537149(office.11).aspx

-simon

Whoa .....

Thats a piece of reading for all the insomniacs out there , i could feel my eyelids droop two sentences in .....

But useful info !