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

R

REVA

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.
 
C

Charles Kenyon

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.
--
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.
 
R

Reva

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top