How to parse one document into multiple files

C

Chutney

I have a document created by Oracle Reports that contains several
hundred invoices. I need to parse the document by invoice, extract a
code from each invoice and save each invoice into a separate .pdf file
using the extracted code as part of the filename. I have just been
given this document to parce and do not know anything about Oracle
Reports or how that application produces the document. I am using Word
2007.

In the formatted file, each invoice is a separate section and all of
the information in the invoices is displayed via individual text
boxes. Outline view shows a simple list of all of the data that is
displayed in the formatted document and the data elements for each
invoice is in the same order. However, the order of the data in the
list is not in the order in which the data/text boxes are arranged in
the formatted document.

I have done some coding in Access and Excel but am not familiar with
the objects and methods in Word. Can anyone suggest how I can:
1. Iterate through the document, section by section;
2. Identify and extract the code in each section that I need to use as
the file name;
3. Save each section to a .pdf file?

Thanks for your help.
 
D

Doug Robbins - Word MVP

Even if you are not using mail merge, see the "Individual Merge Letters"
item on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 
C

Chutney

Doug,

Thanks very much. I have been working with your SplitMergeLetter and
Splitter which are pointing me in the right direction but am having
trouble getting the syntax to work. I will keep working on it.
 

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