#1
|
|||
|
|||
Creating a form autofilled by chart contents
I am a property manager and want to create a tool to be used by my team to populate lease documents. The ideal scenario would be for the first page of the lease to have a chart that is filled out once with information such as:
Address: 123 House Lane Landlord: Home Management, LLC Tenant: Bert and Ernie Lease Start Date: 1/1/17 etc.... I would like to fill this chart out once and have the referenced fields auto-populate our standard lease document. For example the first line would read: "This Agreement, made this date, January 1, 2017 between Home Management, LLC (a Pennsylvania limited partnership), Lessor (also known as Landlord), Bert and Ernie (hereinafter called Tenant)." My most recent attempt is in Word 2016 by inserting a chart and populating the cells using the developer content control tools. I then highlighted each piece and, from the insert tab, link panel, created bookmarks. Within the lease text, I then inserted fields and selected REF and the applicable bookmark. This gives the desired effect for a one time use, but considering this is to be used as a tool for others, it is WAY too easy for the bookmarks to be deleted and way too difficult to type within the bookmark brackets. Protecting only a selection of the document does not work. I figured out that if you make a bookmark by selecting the entire cell instead of just the word, you can't delete the bookmarks as easily. Problem is that the inserted REF literally populates the lease with a one line cell and therefore breaks up the format and paragraph flow. A few questions: Is there a way to link the unformatted contents of the cell instead of the cell itself? Or is there a way to make the bookmarks permanent while leaving their contents editable? From what I have read, no. Would it be better to just create this document in Excel but read as a Word doc? Thank you for your thoughts! Hannah |
#2
|
||||
|
||||
See:
https://support.office.com/en-us/art...B-AC44937E3A9F http://gregmaxey.com/word_tip_pages/repeating_data.html PS: It would help if you used normal terminology. Tables are not charts. Moreover, nothing about your requirements indicates that even a table is needed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a new tab with different kind of chart | aaslezak | Visio | 1 | 08-25-2015 07:08 PM |
Creating custom like table of contents | rehan0129 | Word | 1 | 05-17-2014 07:44 AM |
Creating a table of contents | greneebb | Word | 11 | 03-07-2014 11:02 PM |
How to keep hyperlinks when creating a table of contents | Abacaxi | Word | 3 | 04-18-2012 12:24 AM |
Creating Chart using VB textbox value | shyler82 | Word VBA | 0 | 03-12-2010 06:56 PM |