Extacting data from word document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

agarwalsau - 27 May 2007 07:52 GMT

I am using MS word 2007. I write a huge number of letters with different
reference No. and subjects (these fields are in text format). I would
like to extract this data from every document saved on the computer and
make a database of it in access or excel or even word, which ever is
simple and possible. How do I go about it? It is like the opposite of
mail merge!

Signature

agarwalsau

Reply to this Message

Graham Mayor - 27 May 2007 08:24 GMT

How and where exactly is this information stored in the documents? Is it
always in the same place? How can it be identified?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am using MS word 2007. I write a huge number of letters with
> different reference No. and subjects (these fields are in text
> format). I would like to extract this data from every document saved
> on the computer and make a database of it in access or excel or even
> word, which ever is simple and possible. How do I go about it? It is
> like the opposite of mail merge!

Reply to this Message

agarwalsau - 30 May 2007 08:51 GMT

Graham Mayor;2170443 Wrote:

> How and where exactly is this information stored in the documents? Is it
>
> always in the same place? How can it be identified?

Yes all documents are on the same template with a reference line as the
first line at the top and a subject line after the address line in the
template starting with the word subject

Signature

agarwalsau

Reply to this Message

Graham Mayor - 30 May 2007 10:49 GMT

The reference that you want to extract is the very first line of the
document?
Then there is an address? How many lines does the address take?
Then there is a subject that you want to store?
Can you mail me a sample document to the link on my web site home page and
tell me *exactly* what you want to store?

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Graham Mayor;2170443 Wrote:
>> How and where exactly is this information stored in the documents?
[quoted text clipped - 20 lines]
> the first line at the top and a subject line after the address line
> in the template starting with the word subject

Reply to this Message

agarwalsau - 01 Jun 2007 06:57 GMT

Graham Mayor;2174658 Wrote:

> The reference that you want to extract is the very first line of the
> document?
[quoted text clipped - 3 lines]
> and
> tell me *exactly* what you want to store?

Thanx for the macro. It works perfectly, but had to fine tune it
according to my requirement, as after running the macro i realized that
some doc didin't have either the reference or the subject. Secondly the
subject line sometimes
started with "sub:", Also there were times when body of the letter had
the word "subject" or the reference to the reference no of another
letter . But fixing the macro to take care of all that was easy once
you have the basic framework. Permit me to post the macro on the forum
as i know it would be very useful in huge number of other applications.
One of them I have realized is:- that now i can get/extract a mailing
list from all my letters itself.
Thanx once again

Signature

agarwalsau

Reply to this Message

Graham Mayor - 01 Jun 2007 09:34 GMT

I did ask if all the documents were the same ;)

I'll post the basic code on my web site for future reference.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

>> Yes all documents are on the same template with a reference line as
>> the first line at the top and a subject line after the address line
[quoted text clipped - 12 lines]
> get/extract a mailing list from all my letters itself.
> Thanx once again

Reply to this Message