Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Before you make the spreadsheet, submit any comments that came via email through the form on the website.
  • Export the entries:
    1. From the dashboard, navigate to Collections > Forms > Import/Export.
    2. Select the form of the policy you are interested in.
    3. Check the First Name, Last Name, Email, Comments and File checkboxes.
    4. Click the “Download Export File” button.
  • Open the file in Excel and format the file:
    1. Stretch the Name and Email columns to fit.
    2. Stretch the comment column.
    3. Select the whole comment column, right click and choose “Format Cells.” On the Alignment tab, check the “Wrap Text” box.
    4. If it is necessary to remove extra white space, select the Comments column. In the Cells section of the Home tab, from the Format dropdown, select the “Auto Fit Row Height” option.
  • Save the file. Be sure to save the file in the Excel Workbook format.

Make a word

When adding a final policy to the website

...