Legal pleadings

[Marianne]

I have created pleadings as merge documents. Now, I need
to know how to ask the processor what court they are
recording in and have the appropriate information for
that particular court, i.e. clerk, district, address,
etc. inserted. The information for the 64 possible
courts is contained in an Excel spreadsheet.

Help!! Which way do I go?

 

[Cindy Meister -WordMVP-]

Hi Marianne,

I have created pleadings as merge documents. Now, I need
to know how to ask the processor what court they are
recording in and have the appropriate information for
that particular court, i.e. clerk, district, address,
etc. inserted. The information for the 64 possible
courts is contained in an Excel spreadsheet.

I'm not quite clear on exactly what you have, and what you
expect. But let's start with which version of Word/Office
you're dealing with?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Marianne]

Cindy,

The merge documents are built in Word 2000.

Thanks --

Thanks --

 

[Cindy Meister -WordMVP-]

Hi Marianne,

The merge documents are built in Word 2000.

OK, let's see if setting QueryOptions is what you need. If
it does what you're looking for, but you need a more
user-friendly interface, then you'll need VBA code for
that.

- Set up the merge to the Excel sheet
- Look for the button in the mail merge toolbar with three
dots (its label is "Mail merge..."). click it
- There should be a button on the dialog box this opens
named "Query options". click it.
- Select a field from the list at the top left that
contains unique information for the selecting the court in
question
- From the list in the middle of the top row, select the
equivalent of "is equal to"
- Type the exact information the Excel table contains for
the field in question, to get the record you want

Now, I need
to know how to ask the processor what court they are
recording in and have the appropriate information for
that particular court, i.e. clerk, district, address,
etc. inserted. The information for the 64 possible
courts is contained in an Excel spreadsheet.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail