Copy multiple paragraphs from multiple documents into one document

R

REVA

I need to copy addresses from 1000 documents and put them into one document.
I need a macro that will copy from all documents under one Folder and Paste
them into another document, preferably a Table. I can work with the
formatting later. I located a "How to Find & ReplaceAll on a batch of
documents in the same folder", but I am not good enough to modify it to
Select the correct area and Copy and Paste instead.
 
E

Edward Thrashcort

You will need to open each document to copy data from it

Open your blank receiving document
Use the Dir() statement to get the list of documents
Then open each document in turn and copy the data into the blank document.

Tip:
Instead of creating the table on the fly, capture the data using Tabs to
separate each item in a data record. Then at the end, use Tables|Convert
Text to table to create your table.

Eddie
 
E

Ed

Check out this program: Pathagoras. www.pathagoras.com. I think it does what
you want. It can quickly build and display a listing of all documents in a
specified folder. Select just the ones you want, press Go button and it will
quickly assembly a document containing just the selected sub-documents.

It is a bit on the pricey side if this is just what you want, but Pathagoras
has lots of other features. (It is aimed at law offices and the like. Much
easier to use than its competitors HotDocs, Ghostfill, etc. Those programs
cannot even touch Pathagoras for the feature I described above.)

Ed
==================
 

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