I am trying to perform a mail merge from an Excel document to a Word document. The fields in the source document retrieve text from elsewhere in the Excel document. Thus, the actual fields are in fact formulae. The content of the fields is plain text.
This works fine in most cases, except when the source text is longer than 255 characters. I know that usually one can get around this problem by creating a 'dummy record' at the start of the mail merge which contains more than 255 characters - this forces Word to treat the field as a memo. However, this doesn't appear to work in the case where the field itself is a formula referring to text elsewhere in the document. The result is that any fields with text exceeding 255 characters are simply not displayed at all.
How can I work around this?
Answer
The solution that worked for the poster was to divide the formula,
which was previously in one cell, among several cells where each of the cells was
at most 255 characters in size.
The poster used the MID() function to cut up the text.
No comments:
Post a Comment