Emailed quiz results are formatted incorrectly

Article Last Updated

This article applies to:

Emailed results for a Quizmaker quiz will display pertinent data for each individual question on a separate line.  If one or more line breaks are missing in the emailed results (so that data for two or more questions appears on the same line), this incorrect formatting can make it difficult to import the raw data into a spreadsheet or database for analysis.

If you receive emailed results with missing line breaks, it indicates that there is a setting in the end-user's email client that needs to be changed to correct this behavior for future quizzes.  Here's how to correct this behavior in Microsoft Outlook:

  1. Open Microsoft Outlook on the end-user's computer.
  2. Navigate to the Tools menu, and select Options.
  3. On the Preferences tab, click the E-mail Options button.
  4. Deselect (uncheck) the "Remove extra line breaks in plain text messages" check box.
  5. Click OK to close the E-mail Options dialog.
  6. Click OK to close the Options dialog.

To correct the formatting issue in emails that you have already received, you will need to:

  1. Create a new text document, using a text editor such as Notepad.
  2. Copy and paste the text from the body of the email into the new text document.
  3. Manually enter line breaks at the end of the data for each question.  (Note:  Each line of text that corresponds to a question will begin with a date.)
  4. Save the modified document as a CSV file (which can then be imported into a spreadsheet or database).