How do I collect information from multiple documents to create a t

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REVA - 08 Sep 2005 21:32 GMT

I have 1000 Word documents (letters) and I want to create a Table with the
addresses from all 1000 documents. The documents are layed out the same, but
each document has a different address and was individually typed. I want to
create a table with all the addresses in it WITHOUT HAVING TO RETYPE them
all. I want to "get" the address from each document and create a table so
that I can use Mail Merge from now on. I am using Word 2003 but have access
to 2002 and 2000.

Reply to this Message

Charles Kenyon - 08 Sep 2005 21:44 GMT

This is relatively easy if you used unique styles for your inside address or
a fixed place for the address. See
http://word.mvps.org/FAQs/MacrosVBA/BatchFR.htm
for coding to do a replace on all documents in a folder. This macro could be
adapted to get the address from each of the documents and copy it into a
separate Word document.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

>I have 1000 Word documents (letters) and I want to create a Table with the
> addresses from all 1000 documents. The documents are layed out the same,
[quoted text clipped - 6 lines]
> access
> to 2002 and 2000.

Reply to this Message

Reva - 22 Sep 2005 20:36 GMT

Charles, Thank you for your info. The addresses ARE in the same place in
each document. I am not very good with Macros, but I was able to get the
Find ReplaceAll one to work on my test data. Can you help me with the
adapting Part (to get the address from each of the documents and copy it
into a separate Word document TABLE). I am continuing with the other links
you supplied me, but would appreciate any additional help. Thank you. REVA

> This is relatively easy if you used unique styles for your inside address or
> a fixed place for the address. See
[quoted text clipped - 12 lines]
> > access
> > to 2002 and 2000.

Reply to this Message