Reputation: 53
I have an excel spreadsheet that contains many columns including ones labeled comment1, comment2, comment3, etc. Not all the columns for each row will have text. In another column of the spreadsheet I merge all these comment columns together and add additional wording and punctuation. Here is a sample of the merge formula:
![image of excel formula
]1
It looks fine in the Excel column and when I use Word to merge to an email, it appears okay 95% of the time. Occasionally, with no rhyme or reason I can figure out, it drops the C from the word comment at the beginning of each line. It does not drop any other letter and can be any of the lines from the first comment to the last.
Like this:
COMMENT: comment text
COMMENT: comment text
OMMENT: comment text
COMMENT: comment text
I cannot figure out why or how to fix this to save my life. Any idea would be extremely helpful.
Upvotes: 0
Views: 53
Reputation: 13515
Instead of concatenating all the cells, you could reference them individually in the mailmerge, with your MERGEFIELDs coded as:
{MERGEFIELD Comment1 \b "COMMENT: "}{MERGEFIELD Comment2 \b "¶
COMMENT: "}{MERGEFIELD Comment3 \b "¶
COMMENT: "}{MERGEFIELD Comment4 \b "¶
COMMENT: "}
where 'Comment1' through 'Comment1' are your comment field names.
Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required. Instead of the ¶ symbols, you should use real line/paragraph breaks.
Upvotes: 1