Platform ??" Word 97 & Word 2000 Databases ??" Win 2K SQL 2000 and Oracle 7 Steps 1 ??" 4 search the SQL DB Steps 5 ??" 7 search the Oracle DB 1. Open a letter Template from the Toolbar 2. Pop up box ??" prompt for fee earner initials ie MV 3. If the user has inputted initials that do not exist (Prompt ??" “fee earner is not on the list do you wish to try again???) 4. Populate the document with the Fee earner reference, name, job title, direct dial number, fax number, email address i.e - 01\30\MV\** Joe Bloggs Solicitor Direct Dial No: (01123) 95333 Fax No: (0149) 6123 Email: ******* (We are currently using macros which populate all of this information from another word template. Once the user inputs the fee earner initials, it looks at another word template for the information, but we now want it to query an SQL database) At this stage we wish to connect to the oracle database 5. Pop up box ??" prompt for exact matter number i.e 512343.1 (if the user does not want to search for a matter number, they can click cancel to exit at this point 6. If the search fails, the user gets the option to try again or cancel 7. search successful, the document is populated with the client/matter details i.e client name & address for envelope, salutation and Re (see attached sample letter) these fields will be dropped into bookmarks within the word document (see attached doc with bookmarks for layout)
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
Word 2000 Word 97 Win2k SQL 2000 Oracle 7