3.1 REPLACE/CONCAT may not result in data > 32000 bytes. (11678) - (Business/Routines/RecConnect.p)
Problem
Attempting to send a RecConnect email using an HTML Email Template and got back the following error: REPLACE/CONCAT may not result in data > 32000 bytes. (11678) - (Business/Routines/RecConnect.p).
Solution
Too many characters were used in the combination of email body and template. Reduce its size to send this message.
Note:
If opting to "Copy, Cut, and Paste" text from a pre-generated document, then Vermont Systems highly recommends using .txt or .rtf file documents as the source. Using programs, such as Microsoft Word and .pdfs as your source is not recommended because they insert thousands of extra - often unseen - HTML characters into the code that result in problems ranging from unexpected formatting issues in RecTrac to exceeding the character count in this field.
If you wish to use text from a MS Word doc or .pdf, then Vermont Systems recommends the following "best practice:"
- Open your document in MS Word.
- Save the document as a plain text (.txt) file using Unicode UTF-8 as the file type.
- Use Save As.
- From the Save as type Drop-down down list, select "Plain Text (.txt)."
- From the File Conversion dialog, select the Other Encoding Radio Set Button and choose "Unicode (UTF-8)."
- Save the .txt file to your workstation.
- Open the newly saved .txt file in Notepad or Notepad ++.
- Copy the text to your clipboard and paste it into the RecTrac field.
- Proof-read again for accuracy and ensure all special characters are copied correctly.
- Format text as needed using the Formatting icons at the top of the text box field.