I have a mail merge field called,
My data is bad how do remove the carriage return from this merge field.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
I assume you mean when that field is populated during mail merge but has no data a line break still remains in the document? Microsoft has a tutorial about how to avoid this.
On the Tools menu, click Mail Merge. In the Mail Merge Helper dialog box, click Merge.
NOTE: You must select the main document and data source for the merge before you perform step 2. In the Merge dialog box, under When Merging Records, click either: Don't print blank lines when data fields are empty.
-or- Print blank lines when data fields are empty. Click Close in the Merge dialog box, and then click Close in the Mail Merge Helper.
NOTE: If you made no changes in the Merge dialog box, the Close button is not available. Click Cancel instead.