SAEmailQ record data exceeding 32000 error message when emailing from RecTrac 3.1
Problem
I get the following message when I attempt to send an email out of Rectrac. 'Attempt to update SAEmailQ record data exceeding 32000. (12370) - (Business/Routines/RecConnect.p)
** Unable to update SAEmailQ Field. (142) - (Business/Routines/RecConnect.p)'
How can I fix this?
Solution
It is likely that your character count exceeds the 30,000 character limit, regardless of what the character count field displays. When entering text into an field, VSI strongly recommends that you do NOT copy, cut and paste from MS Word or a .pdf file.
Text copied from MS Word and/or .pdfs insert thousands of extra hidden formatting characters, usually HTML, that needs to be removed before being pasted into RecTrac. These characters do not appear in the character count field.
The hidden formatting eats up characters in RecTrac, sometimes causing you to exceed a field limit. There are also issues with special characters that look correc, for instance - an apostrophe, but when pasted into RecTrac are not valid characters.
This is most often manifested when copying/cutting/pasting text from a MS Word or .pdf doc into an Email field in RecTrac, such as RecConnect report. However, it is generally true when pasting into ANY RecTrac text field, and this practice should be avoided.
VSI Recommended Best Practice:
1 Enter your letter text (as plain text) in the appropriate field. The Text Field will accept to 30,000 alpha-numeric characters. There is a character counter on the lower right-hand corner of the screen.
2 Use the Formatting Icons across the top of the Text Field to manipulate your text as desired. Mouse-hover over the icons for definitions of their purpose. The Text Field is WYSISYG (What You See Is What You Get) formatted.
3 The Text Field always displays plain text when entering this screen. The Source icon can be used to toggle the Text Field between plain text and HTML code, if desired.
If you decide to copy/cut/paste from MS Word or .pdf or other external doc
If you wish to copy/cut/paste text from a MS Word doc into RecTrac, VSI advises the following to convert text from a pre-generated MS Word document:
1 Copy the original document to a .text file editor, such as Notepad. Copying the original into Notepad strips any hidden HTML formatting inherent in MS Word docs and .pdfs.
2 Proof-read for accuracy and ensure all special characters copied correctly into Notepad.
Pay special attention to Smart Quotes (aka: curly quotes), if you use them. Smart Quotes cannot be read and show up as random characters or blocks. IF you have Smart Quotes enabled in MS Word, then VSI recommends doing a Search and Replace in Notepad. Highlight the Smart Quote in Notepad, copy it, and then press <Ctrl> + H to launch the Replace dialog. Paste the Smart Quote into the Find field and manually enter a quotation mark in the Replace field. Click Replace All.
3 Re-copy the text from Notepad and paste into the RecTrac field.
4 Proof-read again for accuracy and ensure all special characters copied correctly.
5 Format text as needed using the Formatting icons at the top of the text box field.