Narrative1 Component: N1-Word.
Symptom(s): N/A
Typical Cause: To use a Report Word document with Narrative1, it must include Narrative1 fields and tables.
Time required to fix: 2 - 3 hours, depending on the length of the Report and the number of fields.
Solution: Insert Narrative1 fields and tables on a global basis using Narrative1’s Fields and Tables tool in conjunction with Microsoft Word’s search and replace function. Follow these steps to convert a Report document to a Narrative1 Report Template document:
Prerequisite
N1 has undocumented features for template development to quickly insert a field or table from Excel to Word.
An Excel/Word merge must be completed at the beginning of the work session, or after a new range name has been added to Excel.
To insert a table in Word
- In Excel: copy the range name to the clipboard (typically located just below the lower left corner).
- In Word: place the cursor at the desired table location and type Alt-t to insert the table.
To insert a field in Word
- In Excel: copy the range name to the clipboard:
- The range can be copied from the Name box at the upper left corner of the Excel UI, or
- Type Ctrl-Shift-C
Known issue: If there are multiple range names in a cell, the code will sometimes copy the wrong name. When this happens, you’ll see “Error! No document variable supplied.” in Word. To fix that, type shift F9 to reveal the field code, then enter the correct range name. Press Shift F9 to toggle the field code off.
- In Word: place the cursor at the desired table location and type Alt-Shift-T to insert the field.
Process for Converting an Appraisal Report
1. Open a Narrative1 Excel Appraisal file and then click on the Narrative1 Ribbon in the menu bar.
2. Click Prep Fields and Tables in the Narrative1 Ribbon. This will allow you to insert any of the Narrative1 fields and tables directly into your Word document.
3. Open your original (non-Narrative1) Report document in Word. We will begin with the fields which have uniform content and formatting throughout the Report. For example, the Effective Date of Value of the appraisal.
4. Click in the Word document next to the EFFECTIVE DATE OF VALUE value (February 12, 2018) so that your cursor is placed there.
5. Click on the Narrative1 Ribbon in the menu bar, then click on Fields and Tables.
6. Find the AsIsValueDate field in the list of fields. You can do this by scrolling through the alphabetized list, or by entering all or part of the field name in the Find in list box and then clicking Find Next to navigate to that field in the list.
7. Now that the AsIsValueDate field is selected, click on the Insert in Doc button to insert that field in your Report document. It will be inserted wherever the cursor was placed.
Note that the AsIsValueDate in the Report document (shaded gray) is a date. That date value is coming from the Narrative1 Excel document we prepped and merged earlier.
8. After inserting the Narrative1 field into your Report document, copy the gray-shaded Narrative1 field. The easiest way to do this is to click on the right side of the field and then hit the backspace key which will select only that field. Then press ctrl+c on your keyboard to copy the content to the Windows clipboard.
9. After copying the field to your clipboard, press ctrl + h on your keyboard to open Word’s Find and Replace function. When the dialog box opens, type in the text string of the value you want to find and replace ("February 12, 2018," in this case) in the upper Find what box. In the lower Replace with box enter in "^c", without the quotes. The "^" (caret) character is Shift+6; the "c" should be lower-case.
This tells Word to replace that particular information ("February 12, 2018") with the contents of the Windows clipboard, which currently holds the Narrative1 AsIsValueDate field.
In the example above, we see the Report document in the background and Word's Find and Replace feature in the foreground. The text string we've entered in the "Find what" field is the Effective Date that already existed in the Report, and which we want to replace with the Narrative1 AsIsValueDate field.
10. Click Find Next. This will go to the next instance of the text string (February 12, 2018) in the Report document. If it is another instance of the Effective Date of Value, click the Replace button. It's important to verify that the content being replaced is actually the Effective Date of Value, however. In the screenshot examples above, both the Effective Date of Value and the Date of Property Inspection are February 12, 2018. If you replace all instances of that date, you will be inserting the AsIsValueDate field for Property Inspection as well as Effective Date of Value.
Note: When the field replaces the text string it will be in whatever Word style it was originally copied. This is simple to correct using Word’s format painter: copy a nearby desired style and paint over the replaced field.
Continue to press Find Next and then Replace for each instance of the Effective Date of Value. Once all instances have been replaced with the Narrative1 field, repeat steps 3 - 10 with the other fields and tables included in your Report document.
If you need additional help, please contact Narrative1 Support at support@narrative1.com or 866-319-7467