Copy multiple paragraphs from multiple documents into one document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REVA - 27 Sep 2005 15:18 GMT

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.

Reply to this Message

Edward Thrashcort - 27 Sep 2005 16:33 GMT

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

Reply to this Message

Ed - 27 Sep 2005 18:12 GMT

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
==================

> You will need to open each document to copy data from it
>
[quoted text clipped - 8 lines]
>
> Eddie

Reply to this Message