 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / August 2003Legal pleadings
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? 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 :-) Cindy, The merge documents are built in Word 2000. Thanks -- Thanks -- >-----Original Message----- >Hi Marianne, [quoted text clipped - 21 lines] > >. 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  SignatureINTER-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 :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.