Centex Form

I need a Microsoft Word 2003 document template that will provide a "form" page with about 20 fields for text and number entry. Then using that info, reference/link it into appropriate places on the next three pages. One of those fields is a drop down list, allowing selection of a paragraph from a hidden section. Finally, an "email" button saves the document, normalizes fields out, write-protects with a password, and includes the doc as an attachment in an email message, and fills in the address and subject line. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). Fine Detail of project: 1. When a new doc is created from the template, it should first prompt for a file name and directory, and then save. 2. The first page/section holds the basic info in fields that will be used in the document. These values should be retained and changeable after reopening the doc. In places where data is to be linked from the first page, I've marked them out with beginning and ending asterisks. "(Joint Tenants)" only appears after the Special Warranty Deed title if the checkbox is checked. If unchecked, remove (Joint Tenants) if it was there. The "Subdivision" list should be a dropdown list that is populated according to the available subdivisions listed in the last section of the template. We need to be able to add subdivisions at a later date without having to change any vb code. The text for the dropdown list is the uppercase wording at the top of the paragraph, and to the left of the "/" mark. The County value is the text to the right of the "/" mark, neither field is to include the "/" or the ":" in the displayed values. The entire text of the following paragraph is to be pasted into the Special Warranty Deed page in place of the *subdivision* text. If the subdivision has a *block* field within, then fill-in should be enabled on the first page, otherwise, disabled and skipped when tabbing. I have included our macro (in an attached module) that converts the numeric representation to alpha. I've been calling it when exiting numeric fields. I wrote it a long time ago. It will need modification to handle numeric mixed with alpha data when parsing a block number for cases like block "1-A" (should come out like "block One-A"). The final display should be like check writing: " Lot numbered Fifty-Six-A (56-A) in Block numbered Thirty-Five (35) of CIELO GRANDE Subdivision..." etc. If subdivision is changed again from the dropdown list, delete the paragraph that is in the doc, and place the new one. 3. On the invoice, "total" should automatically add up from the fee and the tax fields. 4. When all fields are done being entered, and we are ready to deliver the doc, the email button will be used. When it is clicked, here's what should happen: a. Update links and fields. b. Save this document again, using current name. c. Then normalize all links and fields out of the document. d. Delete the first and last sections. Only the SWD, cover letter and invoice should remain. e. Protect document for read only with password: "locked". f. Save as current name + "[login to view URL]". g. open a message in default mail program (we are using outlook), include "-email" version of document as an attachment, and plug in the realtor's email address (somehow saved from before), and the *short name* as message subject. Copy cover letter text into message body. h. Don't send, but allow us to make changes in the message body and click send ourselves. ## Platform Windows XP Pro, MS Office 2003